Lansweeper logo
Home Download Features Demo Buy now Help Support forum
 
    Most requested support articles:
  Lansweeper troubleshooting guide.
  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  WMI Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  How to configure the windows firewall using group policies.
  Support:  
 support@lansweeper.com  
Skype: Lansweeper  
  Mo-Fri 9h-17h CET  
Welcome Guest Search | Active Topics | Log In | Register

Tag as favorite
Creating a custom report
mtaggart
#1 Posted : Friday, April 30, 2010 11:06:10 PM
Rank: Freeware Advanced Member

Groups: Member
Posts: 56
I used the Lansweeper Configuration utility to group software together under the Licenses tab and I want to be able to run a report against those new groupings and am not able to figure this out. I'm not a SQL guy, i'm not a report building person - this is all new to me and I cannot make out how to do this. Any help would be greatly appreciated.

For example, under the Licenses tab, I created a group called Adobe Reader under the box labeled 'Licensed software that you want to keep track of:' and under that, I then added all of the Adobe Reader applications that were found ( I also had configured how many we purchased along with the price).

I would like to run a report against this data (and emailed to me on a scheduled time) to have it report to me what we have and if we're over licensed on the groups that I setup.

Thank you,

Mike
mtaggart
#2 Posted : Monday, May 10, 2010 8:14:26 PM
Rank: Freeware Advanced Member

Groups: Member
Posts: 56
Can anyone help me with this?
Lansweeper
#3 Posted : Tuesday, May 11, 2010 8:43:23 AM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,378
You need the following tables for this: tbllicenses, tblsublicenses,tblsoftware,tblcomputers.
Users browsing this topic
Guest
Tag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Contact: E-mail Lansweeper - Skype : Lansweeper
Copyright 2004 - 2011 © Hemoco bvba