Symantec Management Platform (Notification Server)

Need help with couple tasks I'm trying to accomplish in Altiris 7.1 and I appreciate help and feedback.

1. Need to get list of all reports incuding the custom ones developed in Altiris 7.1 and we have hundreds so I thought would be helpful to have SQL query that provide all the reports and their descriptions exported out.

2. After I get task one completed  then I need to determine if IT Analystics will have the ability to convert some of the reports that we have in our environment including the custom-code reports . I will document the ones that we can convert or rebuild with IT Analystics and ones that cannot be managed or rebuilt by the tool.

Regards,

SamAdmin

Try this:

select vi.*
from ItemClass ic
join vItem vi
    on vi.Guid = ic.Guid
where ic.ClassGuid = 'A968A2A6-C9B9-483B-B9E0-7F0B199F9DA3' --Reports

Thanks dnoah_GMK.. I tried running the query and I got  error.

Msg 208, Level 16, State 1, Line 1

Invalid object name 'ItemClass'.

Check and make sure you are running this against the 'Symantec_CMDB' database and not master or another database.

...or just run it like this (assuming you named your db Symantec_CMDB):

use Symantec_CMDB

select vi.*
from ItemClass ic
join vItem vi
    on vi.Guid = ic.Guid
where ic.ClassGuid = 'A968A2A6-C9B9-483B-B9E0-7F0B199F9DA3' --Reports

That was it, thank you. I also got the following query to work as well

select Name, Description from vItem where classguid = 'A968A2A6-C9B9-483B-B9E0-7F0B199F9DA3'

--attributes not like '1%'

and attributes = 0