![]() Altiris™ Asset Management Suite 7.1 from Symantec. And report costs throughout the. Laptops, mobile devices, and software installed in. List of Computers with Software Package Execution Detail. Summer Report. One comment on “ Some SQL Queries for Altiris 7.x. Altiris report that is an alternative to the built-in Installed Software report, that only counts active managed computers. This report was tested with Altiris 7.1 sp2. Altiris 8.1Introduction Sometimes the Installed Software and Installed Software by Computer reports or Installed Software filters cannot be fine tuned enough to show which computers have certain software applications installed. In this case it is necessary to create an SQL query that gets the desired data from the database and then create a custom report or filter with the query. Altiris 800Please note that Symantec Support does not support custom reports so adaptations must be made by the user. Building a SQL Query To create the SQL query open SQL Management Studio on the SQL Server with the Altiris Database. Select the Altiris database (usually called Symantec_CMDB) in the Object Explorer pane, then click New Query. Paste the following query which lists every software component that is installed on every computer from the Inv_InstalledSoftware table and joins the vComputer and vSoftwareComponent tables to Inv_InstalledSoftware in order to display the names of the computers and software.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2018
Categories |