Video Screencast Help

Software licensing information

Created: 27 Jun 2013 | 1 comment

Hi all,

We are in progress of moving from 7.0 to 7.1 of Altiris.

Previously on our move from 6.9 to 7.0 we did a full migration.

However this pulled in a lot of irrelevant information and left us in a poor condition with our Software licensing information.

I had recreated all this information manually in 7.0 but I do not want to have to do this again in 7.1.

I have found the tables in SQL for




But I cannot work out how to get the detials of which ones relate to which.

Using my limited SQL knowledge i seem to have found some relations but not the ones which would give me the full relationship of

Product, License and Purchases linked to the license.

acn anyone help?


Operating Systems:

Comments 1 CommentJump to latest comment

abhishek_rane's picture


You can clone the existing asset reports related to contract management / picker reports and see the query by editing the report. From that you will get idea about which are the tables related to software Licensing.

Report Paths:

Click the Menu Reports --All reports---Reports--- Service and Asset Management--Contract Management--Software Licensing

Click the menu Reports --All reports---Reports Service and Asset Management--Picker Reports--Asset Management

You can clone the report using context menu option. Once cloning is completed ,you can edit the cloned report and see the query.