Jump to content


karthikj

Established Members
  • Posts

    1
  • Joined

  • Last visited

Everything posted by karthikj

  1. Hi friends, i am looking for a report in sccm 2007 which should give me the old definitions of the servers only , currently iam getting the report including the workstations as well .Please find the sql query used select a.Name0 as "Computer Name",B.Client_Version00 as "Client Version", B.Engine_Version00 as "Engine Version",B.Antivirus_Version00 as "Antivirus Version", B.AntiSpyware_Version00 as "AntiSpyware Version",B.Antivirus_Update_Date00 as "Last Updated Date" from V_R_System A join MS_Forefront_Data B on A.ResourceID=B.machineID order by a.Name0 Request your help in fixing this issue at the earliest.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.