Client Management Suite

 View Only
  • 1.  SQL SCRIPT HELP

    Posted Jun 10, 2014 03:22 PM

    I am writing a Sql script to try and pull a report of all machines that have citrix reciever on them, I also need to pull the pc name and IP address, I created a script but got no results, any help is appreciated.  I am including my script, thanks in advance for your help.

     

    SELECT vc.Name, vc.[User], sci.Name, inst.InstallDate
    FROM vRM_Software_Component_Item sci
    JOIN Inv_InstalledSoftware inst
       ON inst._SoftwareComponentGuid = sci.Guid
    JOIN vComputer vc
       ON vc.Guid = inst._ResourceGuid
    WHERE LOWER(sci.Name) LIKE '%citrix reciever%'

     



  • 2.  RE: SQL SCRIPT HELP