Create Count Reports
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.
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
Answers (4)
Please log in to answer
Posted by:
dchristian
12 years ago
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.
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.
Posted by:
GillySpy
12 years ago
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
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
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,2break 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
Posted by:
Gearshock
12 years ago
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
p.s. gave both your posts +2
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.