Asset Management Solution 7.X: Software License Compliance by Location
Created: 04 Feb 2013 | Updated: 04 Feb 2013
abhishek_rane Symantec Employee
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:
- Make sure that ‘Installed Location’ filed of software purchase is assigned to the particular location
- 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:
- Go to Reports --- All Reports ---- Reports --- Service and Asset Management and using context menu option create new SQL query report
- Give name to report as “Software License Compliance By Location”.
- Edit the report by Clicking on Edit button.
- Add following query parameters.
- 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
Comments
I like this report a lot.
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?
Would you like to reply?
Login or Register to post your comment.