April 7, 2026 at 7:40 pm
I am annoyed. We have a CMS server that has hundreds of servers saved to the "node." I need to query them all at once to get a COUNT of a certain value. I want a total across all the servers, not the total on each server. But because CMS keeps throwing Server Name as the first column in every query I write, I'm getting individual server counts, not the end total.
SELECT ... INTO doesn't work because if I use a local temp table, the totals won't carry over to the other servers. If I use a global temp table, it already exists.
Likewise, creating the table in advance. The kicker is no matter what I do, that Server Name column keeps popping up and preventing me from getting a SUM() or a COUNT() over the total.
For Reasons, I cannot export the data or save it into a database. Does anyone have another solution?
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply