Is there a way to create count reports? For example, x computers live, y computers down. Or we have x computers with software A, y computers with software A version B, and z computers with nothing.

I don't want long lists of computers like most reports, just tallies. I haven't found it within the report creation and am not versed in SQL so I wouldn't know what to do there. I've seen you guys write out a lot of SQL and if this is something that needs working out in SQL I can just deliver that in my report to the bosses, you don't need to use your time with creating a report example unless you really really want to.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

2
Anything involving counts would require custom sql.

Here's a link that might help.

If anything take a stab at the reports and post your results.

We'll help if you get stuck.
Answered 02/15/2012 by: dchristian
Red Belt

Please log in to comment
2
if you include line numbers in your report then that could give you that data.

Also if you have an order by clause in your SQL then order by the column you are interested in. Then use the "break on columns" feature and it will create a post-query count of the data in that section.
e.g

select
LIVE -- of course i don't know what you're using for live
/* blah blah blah */
where
/* more blah */
order by 1,2

break on columns LIVE

Note: while you could combine them it would probably work better if you had two separate reports and one did the LIVE and the other did the DOWN
Answered 02/16/2012 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
Thanks very much for the help guys. This is going to have to be something I work closer with those on the team that know SQL, but these both give me excellent starting positions so thanks again, I appreciate you taking the time to answer.

p.s. gave both your posts +2
Answered 02/17/2012 by: Gearshock
Senior Yellow Belt

Please log in to comment
0
woot!
Answered 02/17/2012 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity