Video Screencast Help

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.