I'm trying to generate a report where it'll show me these attributes (for Microsoft Visio):
- Last launch date (Software -> Package -> Last Started)
- Last duration (Software -> Package -> Last Duration)
- Total launches (Software -> Package -> Times Run)
- Total usage (Software -> Package -> Duration)
* i tried getting the data from query as shown in the brackets, but it doesnt work well (same computer having like 200+ entries)
May I know which query should I go for to get these values?
also, is it possible to generate reports like daily or monthly usage of a specific software (MS Visio, MS Excel for example -- total launches and duration)?
EDIT: added screenshot of what query I used and the Machine Components I choose.. & pic 002 is the result of duplicate entries
I look at your Screenshot (001.jpg) and your issue came from your query.
Your query look in "Software"."Add Or Remove Program"."Program"."Name", but for the column result, you are looking in "Software"."Package"."..."
In this case, your query means that for any computer which have MS Visio in Add Or Remove Program, you want to report any usage for every products on these computers...
That explain why your get more than 200 entries by computer...
The query should use the Package field : "Software"."Package".Name" = "Microsoft Office Visio" for instance.
Today, we don't have any usage data on daily or monthly basic....
Thanks, got that query right and no more dup entries.. however, it does not stat which Visio it is (2007/2010?).
Is there a way other than "Package" to get these values: Last launch date/Last duration/Total launches/Total usage ?
FYI, I need these info:
Computer . Custom Data . Asset Number
Computer . Custom Data . Employee ID
Computer . Full Name
Computer . Primary Owner
Computer . Login Name
Computer . Device Name
Computer . Domain Name
Computer . LDAP User . Title
Computer . LDAP USer . Manager
Computer . LDAP User . Telephone Number
Computer . BIOS . Serial Number
Computer . Software . Package . Last Started
Computer . Software . Package . Last Duration
Computer . Software . Package . Times Run
Computer . Software . Package . Total Duration
Computer . Software . Add or Remove Programs . Program . Name (?)
Computer . Software . Application Suites . Application Suite . Name (?)
Computer . Software . Package . Title (?)
*the name in blue: don't know which to use but I need atleast one to show what software name (example MS Visio 2007, MS Visio 2010); If I choose "Package" . "Title" it will only show as "Microsoft Visio", select the other 2 will give me 200+ entries again (seems like it's showing all the program installed on that particular computer)
PS: FYI, I was assigned to monitor employees certain software usage on monthly basis. Since LANDesk could not generate a monthly report on usage, I'm willing to calculate the usage manually (i.e 1st May total usage MINUS 1st April total usage). However I need to get this report to be generated out accurately and without problem.
To avoid to have 200+ entries, you need to choose only fields on Package section (keep the same section of the query)
So if you want to know which version of Visio is it, you can just add the version of the package... (Computer . Software . Package . Version).
If the version is :
For the name of tha package, you can choose Computer . Software . Package . Name
Concerning the usage on monthly basic, I'm not sure how you plan to do it, but the 2 options I can see right now are:
and sum the total time using based on date (between 1st May and 1st April)
I've done according to simon's suggestion,reports work good but the reset part isnt
See the attached screenshot.
Only allowed to select up to 10 devices at once! You can see the scroll bar is sooo tiny I have to repeat over and over for hundreds of times
Is there a better way to do this? (reset usage)