Symantec Management Platform (Notification Server)

hi,

I need a SQL Query to get the GUID of all the tables created under Symantec_CMDB

Previously i have ran but unfortunately i m not able to run now..

help needed urgently on this...

Just wondering why you need the guid for each table. If you need the schema for querying, it is available elsewhere.

This is an interesting need.  What's up?

Here you can find the database squema for SMP 7.1

http://www.symantec.com/business/support/index?page=content&id=DOC3724

Is this what you were looking for?

Regards:

       Falquian

hi thanks all for your preciuos replies.

now i got to understand that query for particular tables created in symantec_CMDB..

Actually i was in so much pressure that i could not rememberd the simple query.

anywys

again thanks to symantec forums. and all of you ..

Regards,

Hello,

I am stuck in a similar situation as Sandy S above. I am trying to create a dynamic filter using raw sql on Symantec CMDB 7.1 and the below query I am trying to run:

The below query runs perfectly fine on SQL management platform returning all the records however when I try to create an Altiris filter it returns no records.

select  [vri1_Computer].[Guid] AS [_ResourceGuid]  from [vRM_Computer_Item] AS [vri1_Computer]
       left join  [inv_hw_logical_device]  as [ld] on [vri1_Computer].[Guid]=[ld].[_ResourceGuid] 
             where [ld].manufacturer  like '%Hewlett-Packard%' and [ld].Model like '%6545%'

Could you please help me find out what I am missing?

Thanks in advance!

DSouza S

Hi DSouza S

Did you define it as a "Computer" Filter?

I had this issue too, what it solved was to recreate the filter as Computer Filter.

(was on 7.0 but I think it could be similar in 7.1)

Regards

Patrick