Recently, I had a need to delete an SCCM advertisement in the SCCM 2007 R2 console, in order to ensure it didn’t run on any of my test machines. Now, I knew that it wouldn’t run, because it was not being advertised to any collections of which my test machine was a member. But the advertisement was only a test, and I was trying to clean up after myself.
According to Microsoft (link: http://technet.microsoft.com/en-us/library/bb693527.aspx), the way to delete an advertisement from the SCCM console is to drill down through the console (
System Center Configuration Manager /
Site Database /
Computer Management /
Software Distribution /
Advertisements) and right-click ->
Delete the advertisement. Normally, this is a pretty straightforward procedure… IF you know where your advertisement is located.
You see, the SCCM console in which I was working divided the advertisements into sub folders based on the Publishers name, and I could not find a folder for the Advertisement I was trying to delete.
Furthermore, subdividing the Advertisements as such also rendered the “Look For” search field in the console pretty useless; I would have to “Look For” my advertisement in every folder!
SCCM reports can be pretty helpful, and I was able to run a report that gave me just about every piece of data about the advertisement I wanted to delete – except the path to it; the information critical for deleting the advertisement.
A quick Google search led me to this link: http://blog.tyang.org/2011/05/20/powershell-script-to-locate-sccm-objects-in-sccm-console/. Here, I found the Powershell script that helped me find my elusive advertisement.
The only inputs for this powerful and very useful script are the name of your SCCM site server, and the SCCM object ID, which can easily be found through the “All Advertisements” report in SCCM. As it turns out, the folder that contained my advertisement had been accidentally moved under another folder.
It’s great when you find the perfect tool for the job, as I did in this case. I hope you find it as useful as I did. I intend to keep this one around for future use.