Client Management Suite

 View Only
  • 1.  Computers with last OS installed Date

    Posted Feb 13, 2012 06:49 AM

    Hi All,

     

    Can I get a report for the Computers with last OS installed Date.

     

    Thanks



  • 2.  RE: Computers with last OS installed Date
    Best Answer

    Broadcom Partner
    Posted Feb 13, 2012 08:44 AM
      |   view attached

    Hi Dell,

    Try this query

    SELECT vc.Guid as '_ItemGuid',
    vc.Name,
    oos.[Name],
    oos.[Install Date]
    FROM vComputer vc
    JOIN Inv_OS_Operating_System oos ON oos._ResourceGuid=vc.Guid

    See attachement for detailed instructions...

    Network23

    Attachment(s)



  • 3.  RE: Computers with last OS installed Date

    Posted Feb 13, 2012 10:43 PM

    Thanks a lot Network23!!

    Can you please provide me the the Database Schema for NS7/7.1.

     

    Thanks in advance.



  • 4.  RE: Computers with last OS installed Date

    Broadcom Partner
    Posted Feb 14, 2012 03:03 AM

    Hi Dell,

    Try this link: http://www.symantec.com/docs/DOC3724

    Network23



  • 5.  RE: Computers with last OS installed Date

    Posted Feb 14, 2012 07:02 AM

    Thanks a lot!!!