Hello Guys,

I am currently a student apprentice and my task is it to create Reports with the Symantec Management Console. My Problem is that there is no Database Schema where i can see how the tables are connected.

Now I am trying to make a Drilldown Report , where I am clicking on a Client and want to see all Software packages that are deployed to this client.

My problem is, that I dont know which tables I have to join to get the related Information i need.

please find database Schema

Symantec Management Platform 7.1 Database Schema

Hi Seits,

Please read the Symantec Management Platform 7.1 Database Schema documentation:

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

Thank you for the fast answers, the schema looks like i would just expand all tables at the database server.

Is there a Schema with a focus on how the tables are connected for example an Entity Relationship Diagramm.

Maybe im just to new to this whole topic but i can only see the primary keys of the tables.

I now  joined the Inv_AeX_SWD_Status_Summary with the Inv_AeX_AC_Identification on resourceGuid.

I hope this will work out.

Yes, we use guid#s as our unique identifiers.  Your join should map SWD status summary data to the actual machines it relates to.

Hello guys,

I am now facing another problem with the joined tables. I am trying to show all computer where a specific Software is not installed, i made a query where i am joining

Inv_AeX_SWD_Status_Summary join Inv_AeX_AC_Identification

on Inv_AeX_SWD_Status_Summary._ResourceGuid = Inv_AeX_AC_Identification._ResourceGuid

and filtering all computer where the AdvertisementName != the specific Software.

My Problem is now that there are Computer in the query listed that have the Software installed but the Software is not showed in that query. The Software is only showed if search for the Computer in the Symantec Management Control.

Hi, is there a possibility that i can make a query that give all computer where a specific software is not installed? Like the view in Symantec management console.

I tried a join but i looks that I get different results

Inv_AeX_SWD_Status_Summary join Inv_AeX_AC_Identification

See this thread

http://www.symantec.com/connect/forums/report-software-not-installed

http://www.symantec.com/connect/forums/altiris-ns-find-list-machines-without-installed-software