Client Management Suite

 View Only
  • 1.  Database Issue..!!

    Posted Feb 13, 2012 09:55 AM

    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..!!!



  • 2.  RE: Database Issue..!!

    Posted Feb 13, 2012 12:49 PM

    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)



  • 3.  RE: Database Issue..!!

    Posted Feb 13, 2012 02:21 PM

    You might do something like

    SELECT vc.Name, vc.[OS Name], vc.[OS Version], vc.[OS Revision] FROM vComputer vc

    Does this help?



  • 4.  RE: Database Issue..!!
    Best Answer

    Posted Feb 13, 2012 02:28 PM

    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



  • 5.  RE: Database Issue..!!

    Posted Feb 14, 2012 02:09 AM

    @donald_noah

    Thankyou so much for reply..!!

    Now I know whats happening inside



  • 6.  RE: Database Issue..!!

    Posted Feb 14, 2012 02:11 AM

    @mclemson

    Thankyou so much for the reply.

    Thankss for the sql query..it worked for me..!!