Internal Monitor – RAWSQL – Machine’s running Office 2007 (V12) or Earlier

2017-11-10T22:14:58+00:00November 10th, 2017|

I thought this one of mine was worth sharing, especially helpful if you need a method of mass generating alerts/tickets/warnings for clients running Office 2007 or earlier.

Internal Monitor – SOFTWARE – Office 2007 or Below Installed – Zipped SQL Download

Install Instructions:

  1. Extract the .SQL file out of the zip download above
  2. In the LabTech CC, go to Tools > Import > SQL File and select the SQL File
  3. Go into Monitors > Internal Monitors and search for Office 2007, the monitor is called SOFTWARE – Machine running Office 2007 (v12) or earlier. Open the monitor
  4. Make a note of the following number on the monitor (if the number is not there, go to Tools > Show IDs on the main Labtech CC and re-open the monitor:
  5. Open the Configuration tab, and add this additional condition to the end of the monitor, replacing xxxxxx with the number you took in step 4. This is required in every RAWSQL monitor where you need to set exclusions:
  6. Set the relevant groups that you want to target on the monitor target tab, if you want to select all agents target the All Agents group. Hint – to add a group, right click in the white area in the monitor target tab. Second hint, press the first letter to skip to the group letter name if you get tired of scrolling.
  7. Click “Build and View Query” and ensure it runs and brings back expected results AND it does not bring any mismatches of the Office Product that you may not want, as the goal here is to detect the full Office suite. If you find the monitor is matching an application you don’t want to alert on, add the following line to the end for each occurence:
    1. AND NAME NOT LIKE ‘%NAME HERE %’

  8. Once you are happy you need to set the Alert Template so the monitor actually alerts. At present the Alert Template is do nothing – you will need to set however you want to alert on the monitor on this tab.

If you want to create your own monitor instead of downloading the template one I have supplied, here is the RAWSQL statement:

 

I hope this works well for you!

Leave A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.