This custom SQL report that allows you to determine which devices have specific Discovered software on them.
Note: Reports are not supported by Quest Technical Support. While Support can help identify issues related to the appliance, the design, creation, modification, and troubleshooting of Custom Ticket Rules fall outside the scope of Support.
Customers requiring assistance with Custom Ticket Rules can engage the KACE Consulting & Solutions Architecture (Professional Services) team for implementation and customization assistance:
Click Reporting | Reports | Choose Action | New (SQL).
Enter your report Title, Category, and Description fields and add the following SQL:
select |
*NOTE - You would need to change the line that reads SV_MDS.NAME rlike 'NAME_REGEX' for software packages.
For Suites, enter the following SQL:
|
