Database Issue..!!
Updated: 14 Feb 2012 | 5 comments
This issue has been solved. See solution.
What I wanted to get a report of all the machines showing machine name, Os Name , Version and Service Pack.
I am not getting OS of a few managed machine in Inv_AeX_OS_Operating_System database while I am getting OS Name in vComputer.
Can you suggest how to proceed..!!!
Discussion Filed Under:
Comments
The OS Name you are returning
The OS Name you are returning from vComputer is NOT based off of the Inv_AeX_OS_Operating_System table. It is actually coming from Inv_AeX_AC_Identification. Using this table instead should give you what you are looking for (OS Name, Version, and OS Revision aka Service Pack)
Donald Noah, Systems Engineer
Intuitive Technology Group -- Symantec Platinum Partner
Sample query
You might do something like
SELECT vc.Name, vc.[OS Name], vc.[OS Version], vc.[OS Revision] FROM vComputer vc
Does this help?
Mike Clemson, Senior Systems Engineer
Intuitive Technology Group -- Symantec Platinum Partner
Oops, NS6
In NS6 it might look something like this
SELECT vc.Name, vc.[OS Name], vc.[OS Version], oos.[Service Pack]
FROM vComputer vc
JOIN Inv_AeX_OS_Operating_System ON oos._ResourceGuid=vc.Guid
WHERE vc.IsManaged=1
Mike Clemson, Senior Systems Engineer
Intuitive Technology Group -- Symantec Platinum Partner
@donald_noah Thankyou so much
@donald_noah
Thankyou so much for reply..!!
Now I know whats happening inside
@mclemson Thankyou so much
@mclemson
Thankyou so much for the reply.
Thankss for the sql query..it worked for me..!!
Would you like to reply?
Login or Register to post your comment.