Video Screencast Help
Search Video Help Close Back
to help

Asset Management Solution 7.X: Software License Compliance by Location

Created: 04 Feb 2013 | Updated: 04 Feb 2013 | 1 comment
Language Translations
abhishek_rane's picture
abhishek_rane Symantec Employee
0 0 Votes
Login to vote

Some organizations purchase license based on locations. This article will help user to generate a report to track Software License Compliance with respect to locations.

Prerequisite before creating report:

  1. Make sure that ‘Installed Location’ filed of software purchase is assigned to the particular location  

 

  1. Make sure that ‘Location’ filed of Edit/Create page of computer is assigned to same location as a Installed location mentioned above for software purchase.

  

 

Steps to run:

  1. Go to Reports --- All Reports ---- Reports  --- Service and Asset Management and using context menu option create new SQL query report
  2. Give name to report as “Software License Compliance By Location”.
  3. Edit the report by Clicking on Edit button.
  4. Add following query parameters.

 

  1. Put the attached query into “Parameterized Query” section of ‘Data Source’ and click on Save Changes.

 

Resultant Report:  

 

Explanation:  This report gives compliance based on location. ‘Microsoft SQL server 2008’ software product displayed in the report is purchased for Pune and Mumbai locations. Purchased, Installed and Compliance quantity displayed in the report is based on the location

Attachment : Software License compliance by Location.zip

 

  

Article Filed Under:
, , , , , , , ,

Comments 1 Comment • Jump to latest comment

seabrig29's picture
seabrig29
Asset Management Solution 7.X: Software License Compliance by Location - Comment:29 Apr 2013 : Link

I like this report a lot.  Its helped out in some situations.  However there seems to be a piece lacking that I cant figure out.  How do I assign the # of Licenses to a particular location.  So if I have 1 purchase order for 100 licenses and I have 4 locations, Do I have to write up 4 different Software Purchase entries and 4 different licenses?  that way I assign the correct number to the correct location?  That seesm to be the only way I can figure out how many each location is suppose to have.  That seems to be a terribly clunky way of doing it.  Wouldn't it be easier to write up a multi line dataclass that allows you to assign the number of licenses to either your enterprise, or split it up to verious locations? 

0
Login to vote