Symantec Management Platform (Notification Server)

 View Only

  • 1.  SQl query in NS for software installed date in system.

    Posted Apr 20, 2009 10:35 AM


  • 2.  RE: SQl query in NS for software installed date in system.

    Posted Apr 20, 2009 10:43 AM
    What are you looking to accomplish? Software only installed by Altiris (you could use Software Delivery execution data there), or however it was installed on the system? Most of that stuff would most likely come from add\remove programs.


  • 3.  RE: SQl query in NS for software installed date in system.

    Posted Apr 20, 2009 12:52 PM
    Hi


    I am looking for the report that shows the softwares installation date to be pulled via report in NS.

    I need an SQL query for that,can u help please .

    i agree with you that it has to be taken form add/remove prgm.
    i have the query for that .. but not able to get exact variable to extract the installed date for application in system.

    thanks
    Shuaib


  • 4.  RE: SQl query in NS for software installed date in system.

    Posted Apr 20, 2009 04:06 PM
    There is no InstalledDate column in the Inv_AeX_OS_Add_Remove_programs dataclass/table (at least in Inventory 6.1) which is the only place I can think of that you could get that information.


  • 5.  RE: SQl query in NS for software installed date in system.

    Broadcom Employee
    Posted Apr 21, 2009 01:20 PM
    As Kyle stated the InstalledDate isn't a default field that is gathered during the Inventory tasks. However if you know how this information is stored in the registry it should be possible to setup a custom inventory that pulls this information.