Go Back   PackageDeploy Application Packaging Forums > Package Development > Application Deployment > Microsoft SMS 2003

Reply
 
LinkBack Thread Tools Display Modes
Old 03-15-2010, 06:55 PM   #1 (permalink)
Mark
Guest
 
Posts: n/a
Default Software metering reports

Hello!
I am new to SQL (read no clue at all where to start) and am trying to get
two of the supplied reports in SMS 2003 together with some mods. Is there
anywhere I can download premade queries/reports or do I have to try learning
SQL (crash course style)?

Here is what I'm trying to get:
"Users that have run a specific metered software program"
and
"Time of day usage summary for a specific metered software program"

What I need is everything from the "Users..." report along with just the
actual time of day usage from the other one for each user..
I would also like it to pull all of the metered software instead of just one
at a time. I only have 6 but don't want to have to run each one everytime I
need it.
And if possible, the entire year instead of just a month at a time. So it
would only ask for the year, and then just do the rest.


Thanks in advance for any help!
Mark



  Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:07 PM.


vBulletin, Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
2007 - 2012 PackageDeploy.com