Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Software metering reports

2 views
Skip to first unread message

Mark

unread,
Feb 17, 2010, 4:02:36 PM2/17/10
to
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

0 new messages