Month: February 2011

Posted on February 21, 2011 by | 0 Comments | 4,483 Views
Create a new report and paste the following query into it.This needs prompt as well to list the applications installed on computers . Select Distinct sys.Netbios_Name0, sys.User_Domain0, sys.User_Name0 FROM v_R_System sys JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID WHERE sys.ResourceID not in (select sys.ResourceID from v_R_System sys JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID where…
Read more »

Posted on February 17, 2011 by | 4 Comments | 84 Views
Today morning I step into office and just checked my mails .I saw mail from microsoftcommunitycontributor saying Dear Eswar Raju, Congratulations! We’re pleased to inform you that your contributions to Microsoft online technical communities have been recognized with the Microsoft Community Contributor Award. I should thank to all who has given me the support especially…
Read more »

Posted on February 16, 2011 by | 8 Comments | 5,005 Views
This report gives you list of PCS where no user logged into the computer since 20 days.If the SCCM clients has any issues in sending inventory information to site server,you will see lot of computers though user logged into the computer. select a.Name0,a.UserName0,TimeStamp from v_GS_COMPUTER_SYSTEM a ,v_FullCollectionMembership b where DATEDIFF(dd,a.TimeStamp,GetDate()) > 20 and  b.CollectionID =…
Read more »