Report gives you all the installed applications excluding software updates .You can also customise to add other sec updates which you dont want them in report by adding  AND A.DisplayName0 NOT LIKE "name" at the end of report. SELECT A.DisplayName0,A.InstallDate0 A.Version0,A.Publisher0 FROM v_GS_ADD_REMOVE_PROGRAMS A, v_GS_COMPUTER_SYSTEM B WHERE A.ResourceID = B.ResourceID AND A.DisplayName0 NOT LIKE ‘Hotfix…

Below listed the basic reports to display computers with particular add and remove application installed on computers. Report to list all the computers which have particular software/application installed ? SELECT c.Name0, a.DisplayName0 FROM v_GS_ADD_REMOVE_PROGRAMS a, v_R_System c WHERE a.ResourceID = c.ResourceID AND a.DisplayName0 like '%Adobe acrobat%' GROUP BY c.Name0, a.DisplayName0 ORDER BY c.name0 You can…

this post is just to make the application deployment easier.when you deploy any application to a collection,you might see faliure,no status and waiting.I had similar issues(number count was more).This collection gives you list of systems with faliure/no status/waiting status for particular advertisement.if you need more ,just customise it. Collection: select sys.ResourceID,sys.ResourceType,sys.Name,sys.SMSUniqueIdentifier,sys.ResourceDomainORWorkgroup,sys.Client from sms_r_system as sys inner…
SCCM report for Computers Asset information including SN Number and model name

SMS/SCCM report with Asset Details information: I had a question from my boss to get list of computers that consists of computer name,model ,last boot up time and other important information.You can also customize it according to ur needs but the basis information that gives from below report. This reports provides an asset manager’s summary…

I has an issue with the distribution or removal packages from retired / orphaned DP where the packages are distributed to DP but the distribution point are really not on the network (retired ).Because of this, I see the red alerts on the system status with below error. Possible cause: The distribution point might not…