Thanks to the following article which enlightened me on what I should do to rectify this issue.
http://blogs.technet.com/b/configurationmgr/archive/2010/03/11/fix-no-advertisements-are-listed-in-the-sccm-console-on-a-remote-machine-but-they-do-show-up-on-the-site-server-itself.aspx
Apparently, a file AdminConsole.xml which defines the viewing rules for the SCCM console has an incorrect query to retrieve the Advertisements.
Incorrect Query :
SELECT * FROM SMS_AdvertisementInfo WHERE NOT (AssignmentID = NULL) ORDER BY AdvertisementName
Correct Query :
SELECT * FROM SMS_AdvertisementInfo WHERE NOT (AssignmentID IS NULL) ORDER BY AdvertisementName
Now instead of installing the hotfix, I did it in a much faster way since it's just modifying the xml file.
-
Open the XML folder location eg:C:\Program Files\Microsoft Configuration Manager Console\AdminUI\XmlStorage\ConsoleRoot
- Edit the AdminConsole.xml file (by opening it via NotePad)
- Search for the Incorrect Query (as mentioned above)
- Replace it with the Correct Query (as mentioned above too)
- Save the XML file
- Restart your console
