Symantec Management Platform (Notification Server)

Dear All,

I have often wondered if it was possible to get a report of the installed SMP Solutions that are installed upon a Server? I have tried running the Altiris Profiler on a machine as the SIM was starting up, but I get nothing like good SQL to get the installed products. I have looked into the "Products" table and matched that against vItem with:

SELECT * FROM Product p JOIN vItem vI ON vI.Guid = p.ProductGuid

And this gets a list that looks a bit ramshakle, but I cannot find anywhere where the version can be found.

So, does anyone have a SQL Query that I can run on a Server to find its installed solutions and versions?

At least, if no one comes back with an answer, at least others know as well...

Kindest regards,

QuietLeni

Did you try to use a "My Portal" page and add there "Installed Products" web part? Or this is not applicable for you and you want only a SQL Query?

Hi,

Please take a look at this KB: http://www.symantec.com/business/support/index?page=content&id=HOWTO10744

Quote from it:

===============

The attached report can be imported into your Symantec Management Platform installation to query the database for currently installed products and their version.

Please note that there are some cosmetic display differences between the information stored in the database and the information available from the Product Listing displayed by Symantec Installation Manager.

===============

HTH,

Alex.

Ahhh! vProduct!!!! That was where I was missing the information!

Also, why can I never find the information that I am looking for in the KB articles?

Thanks Alex.

No prob :)

Alex.

(Google -> search string is: "installed solutions and versions altiris")

Oh yes - using the golden rule of "Google finds it better than the SymWise Engine does"!