Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Computers with last OS installed Date

Created: 13 Feb 2012 • Updated: 13 Feb 2012 | 4 comments
This issue has been solved. See solution.

Hi All,

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

Thanks

Comments 4 CommentsJump to latest comment

Network23's picture

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

AttachmentSize
Install_OS_Date_report_simple.docx 29.21 KB
SOLUTION
Pravash Sahu's picture

Thanks a lot Network23!!

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

Thanks in advance.