Today,I come across several advertisement status message IDs for a particular advertisement which can be viewed under system status--->advertisement status. I,Thought of sharing the excel sheet with you about all the advertisement status message ID’s with its description along with. This might be helpful in creating reports or collections with status message ID’s. Download the…

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…