Jump to content

All Activity

This stream auto-updates     

  1. Today
  2. (B)admin Life

    ScriptletsPack

    Very useful pack of scriptlets . Have not thoroughly tested all of them but the ones I have used such as the 'process text one line at a time' have worked great.
  3. Yesterday
    Fantastic work as always Darren. You are a god. This helps us catch things that have changed post configuration of the plugin without having to manually check.
  4. Version 1.0.1

    3 downloads

    The AD Plugin will not operate properly if credentials are missing or are not valid. This monitor will report any Domain Controller Infrastructure Master that does not have valid credentials associated with it. This is the same information available in the plugin, but you can be automatically notified when there is a problem instead of having to check it manually. Thank You to @Jacobsa for the suggestion!
  5. Last week
  6. mr.wallstrom

    Bitlocker Enabled

    Two things -- First, mrmmbels, you can identify it by 'roles'. For example, under advanced search, you would use computer.extra data field.computer role.bitlockerenabledis (true or false). Second - Has anyone seen issues with this not properly detecting on the agent itself, since the v12 udpate? We were running about 95% accuracy with this, but after the update, we're probably around 60%. Techs are getting tired of checking on machines that have already been updated with Bitlocker, and asking me to fix it. Thanks!
  7. Earlier
  8. SteveIT

    Script Backup

    Excellent script!
  9. marktomsovic

    Script Backup

    This is excellent and it's obvious that a great amount of work went into it, thanks for sharing.
  10. Jacobsa

    Script Backup

    Another fantastic script. I had a couple of team members start to worry about script modifications and began to make their own archives within script folders. Implemented this, does exactly as it says it would, now they don't need to worry. Thanks again Darren.
  11. leebaxter

    Alert When Agent Is Online

    Hi Michael If you go to the System>General>Import, you have options to import "SQL File" and "XML Expansion", the .zip file contains both files to be imported. If you do not have these then your permissions on your user account may need extra permissions added. Hope that helps you. Lee
  12. MGreen

    Domain Computers without Automate Agent

    Imported! Lets see if we're missing any @DarrenWhite99
  13. michaelp_IIS

    Alert When Agent Is Online

    Newbie here. I'm not finding how to import this in v12.
  14. Version 1.0.0

    5 downloads

    This script takes a filename to capture as a parameter. The output is a PowerShell script capable of restoring the original file. The output will be no more than 70 characters wide and is Base64 encoded. The original filename and path is also Base64 encoded Unicode, so any valid file (even with international or Emoji characters) can be captured. The file timestamp is also captured and restored. This is meant as an alternative way to capture binary content that can be transmitted as plain text and used to easily re-create the file just by running a script. The capture and restore has been tested with PoSH2/Server2003 and Windows 10. Example to Capture: powershell.exe -file captureportablefile.ps1 "c:\filetoretrieve.dat" > restorefile.ps1 The contents can also be placed in the "Execute Script" function with a filename specified as a parameter. (Include quotes around the path if it has spaces). The output script will save the file with the original name\path, or it will accepts a filename parameter for the new file to save to. The output can be used directly in "Execute Script" to re-create the file, on a different agent for example. The script will indicate success or failure restoring the file. Example to restore: powershell.exe -file restorefile.ps1 Example to restore to a different path: powershell.exe -file restorefile.ps1 "c:\newfiletosave.dat" Here is en example of the script output. Running the script below will create a file named "C:\Windows\Temp\Have a ☺ day.zip" $Base64FileName = @' QwA6AFwAVwBpAG4AZABvAHcAcwBcAFQAZQBtAHAAXABIAGEAdgBlACAAYQAgADomIABkAGEAeQA uAHoAaQBwAA== '@ $TimeStamp=[DateTime]636604097389163155 $Base64Contents = @' UEsDBAoAAAAAAP0Am0zn48F+HAAAABwAAAAZAAAASGF2ZSBhIGhhcHB5IGRheS1BTlNJLnR4dEp 1c3Qgc29tZSA/pD8/Pz8/Pz8gc3R1ZmYuDQpQSwMECgAAAAAA6QCbTORcBzs6AAAAOgAAABwAAA BIYXZlIGEgaGFwcHkgZGF5LVVuaWNvZGUudHh0//5KAHUAcwB0ACAAcwBvAG0AZQAgADomPCZrJ jsmQiZqJmAmYyZAJiAAcwB0AHUAZgBmAC4ADQAKAFBLAwQKAAAAAADxAJtMeDSP5jEAAAAxAAAA GQAAAEhhdmUgYSBoYXBweSBkYXktVVRGOC50eHTvu79KdXN0IHNvbWUg4pi64pi84pmr4pi74pm C4pmq4pmg4pmj4pmAIHN0dWZmLg0KUEsBAj8ACgAAAAAA/QCbTOfjwX4cAAAAHAAAABkAJAAAAA AAAAAgAAAAAAAAAEhhdmUgYSBoYXBweSBkYXktQU5TSS50eHQKACAAAAAAAAEAGACFbKN39t3TA UCsDnT23dMB8s/tc/bd0wFQSwECPwAKAAAAAADpAJtM5FwHOzoAAAA6AAAAHAAkAAAAAAAAACAA AABTAAAASGF2ZSBhIGhhcHB5IGRheS1Vbmljb2RlLnR4dAoAIAAAAAAAAQAYANODVGD23dMB0T1 GLPbd0wHRPUYs9t3TAVBLAQI/AAoAAAAAAPEAm0x4NI/mMQAAADEAAAAZACQAAAAAAAAAIAAAAM cAAABIYXZlIGEgaGFwcHkgZGF5LVVURjgudHh0CgAgAAAAAAABABgAYx1uafbd0wFjHW5p9t3TA YN/S2n23dMBUEsFBgAAAAADAAMARAEAAC8BAAAAAA== '@ $FileName=[System.Convert]::FromBase64String($Base64FileName) $FileName=[System.Text.Encoding]::Unicode.GetString($FileName) If(($Args) -ne $Null) { If($Args[0] -match '^[^\*\?]+$') {$FileName=$Args[0]} Else {Write-Output 'Invalid Filename.';break} } Try { $FileContents = [System.Convert]::FromBase64String($Base64Contents) $Null=Mkdir $(Split-Path -Path $FileName) -EA 0 Set-Content -Literal $FileName -Value $FileContents -Encoding Byte (Get-Item $($FileName)).LastWriteTimeUtc=$TimeStamp Write-Output "File restore complete: $($FileName)" } Catch {Write-Output "File restore failed: $($FileName)"}
  15. marktomsovic

    DNS Forwarder Check

    This helped us find and clean-up some poorly configured servers, thanks for sharing. We've recently had some false-positives with one client in particular who has a terrible Internet connection and I'm looking into ways to deal with that as a separate issue.
  16. marktomsovic

    DNS Forwarder Check

    @DarrenWhite99 How are you handling this monitor's alerts that are generated when the server's Internet has an interruption?
  17. DarrenWhite99

    Computer Audit Dataview

    Version 1.0.1

    14 downloads

    This Dataview incorporates some data from the Disk Inventory Dataview and the Computer Chassis Dataview, including Video Card, Memory, and CPU columns.. I created it when a client asked for assistance gathering this information. The first time we exported from multiple Dataviews and merged the columns in Excel. The next time they asked I made this so that 1 Dataview had all the columns that were important in this instance. Perhaps you would like these columns in a single Dataview also. The SQL is safe to import through Control Center->Tools->Import SQL. The Dataview should be added into the Inventory folder.
  18. GGG

    Add Ticket ExternalID to Dataviews

    Hi. Thanks for the script. I have a question. Would this show the External ID (CW Manage ticket id) in the email notification that is sent to the user as well? Thanks
  19. leebaxter

    Alert When Agent Is Online

    Excellent addition to the system, we are using this to put our email addresses onto agents that are offline for long periods of time (we all have them!) to notify us if it comes online in the period while we are investigating where the machine has gone! This goes a long way to not using up licenses on dead machines. Top marks!
  20. leebaxter

    Alert When Agent Is Online

    Hi Darren Thank you very much for this update, I have updated the components and it seems to be working as expected. Thank you very much for putting in the time to update it, it is very much appreciated. This helps us hugely when our agents go offline for a long period of time and we can then use this to notify us if it comes back online while we are contacting the customers to find out whats happened to the machine. Top marks! Lee
  21. Version 1.0.0

    11 downloads

    I got tired of the useless/wrong BAD PROCESS tickets created by the stock "PROC - Bad Processes Detected" monitor, such as the "Reg.hta" classification alerting when Reg.exe is found running. This SQL will clone the stock monitor (Or update itself if you run it again) targeting the same computer groups, and using the same alert settings. (If you have removed the stock monitor it will still create the new one but it will not target any specific groups). This monitor has been adjusted to only match when the process executable matches the Bad Process Executable name. In a perfect world it would match based on the entire path, but the process classification table only holds the EXE name. Still, this should be much more accurate, much less noisy, and when you re-classify a process you are doing for the EXE name, not just the process title. This SQL only creates/updates the new monitor, so don't forget to disable the alerts assigned to the stock monitor or you will get tickets from both of them.
  22. DarrenWhite99

    Add Ticket ExternalID to Dataviews

    Version 1.0.0

    8 downloads

    The attached SQL will modify all dataviews that include a ticketid to also include the external ticketid as "Ticket External ID". I suggest copying one or a few of the stock Dataviews, and then running this. While it will update all dataviews with ticket information, many will be flagged as having changes the next time Solution Center is ran and may be reset to original. The copied Dataviews should preserve the additional column. Save the file and import into Control Center using Tools -> Import -> SQL File. It will ask if you want to "Import 1 Statement into the database". If it says there are many statements choose "No", you have an older (buggy) Control Center and you will need to import using SQLYog or some other tool. Keywords: remote monitor free drive drives disk disks volume volumes mounted mount point no letter space percent percentage
  23. DarrenWhite99

    Alert When Agent Is Online

    The v_extradatacomputers reference is actually to a table, not a view. It is refreshed about twice an hour but is only rebuilt daily or perhaps weekly, meaning that new EDFs may take some time to appear there. #To rebuild the table (drop and rebuild the complete structure with all current computer EDFs as columns), run: call v_ExtraData(1,'computers'); #To refresh the table (update the values for existing columns in the table), run: call v_ExtraDataRefresh(1,'computers'); However, I have posted an update that no longer uses this table (avoids the build and view error, and is works immediately on live values) and also calls v_ExtraData for you to ensure the table is built correctly. The script should be the same, just download the new file and import the .SQL. It will automatically update the existing monitor for you!
  24. leebaxter

    Alert When Agent Is Online

    Hi Cory Thank you for that, I have been doing a bit more digging this afternoon and it seems we have one of the views missing, I pasted in the SQL query into MySQL yog to get a more concise error and it came back with this, Query: v_extradatacomputers Error Code: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'v_extradatacomputers' at line 1 After checking the views in the database we seem to have the view missing v_extradatacomputers in our database! so I am currently following up to see how to restore this. Lee
  25. cgegg

    Alert When Agent Is Online

    leebaxter, When I first created the monitor it was not working, but I just left it over night and the next day the monitor was working correctly. I'm not sure which function refreshed to get it working but I would imaging if you Refresh Searches, Do Group Refresh and restart the database agent it will probably start working. I was a little impatient when I originally posted. Hope this helps. Thanks, Cory
  26. leebaxter

    Alert When Agent Is Online

    Hi Cgegg I am in the same position as yourself, when I try to "Build and View Query" I get an SQL error also, I have checked the syntax multiple times against Jacobsa post but it does not seem to work. Can you advise if you did get this working in the end? Thank you Lee
  27. mrmmbels

    Bitlocker Enabled

    How would you do this? "Once the role is detected, you can reference it in a search and you can check for it in a script. "
  28. DarrenWhite99

    Agent Status and User Idle Time Dataview

    Some information on Dataview Formatting can be found here: https://www.labtechgeek.com/topic/3428-dataview-formatting/
  1. Load more activity
×