SQL help

[cwilloug]

When I moved my SQL report over to the new (7.1.4.100) Operations Center, the format has changed. When I run the SQL statement from the command line, it looks perfect, but not so much coming from TOC, any ideas?

SELECT DATE(SUMMARY.START_TIME) AS Day, Sum(SUMMARY.BYTES)/1073741824 AS GB from summary WHERE (activity='BACKUP' or activity='ARCHIVE') GROUP BY DATE(SUMMARY.START_TIME)

Show up in email formatted:


GB

DAY
2992 {"date":"2015-12-14","tzo":-21600,"type":1}

3563 {"date":"2015-12-15","tzo":-21600,"type":1}

4194 {"date":"2015-12-16","tzo":-21600,"type":1}

4852 {"date":"2015-12-17","tzo":-21600,"type":1}

5125 {"date":"2015-12-18","tzo":-21600,"type":1}

7046 {"date":"2015-12-19","tzo":-21600,"type":1}

 

[ADSMNewbie]

Hm.. I thought I can figure it out, but I can't. Can someone else help?

*push*

 

[cwilloug]

My old reports are formatted correctly, with the same script, and when I run this SELECT from the command line as well.

Any suggestions?


Daily Backup Numbers

DAY GB
------------------
2015-12-17 4852
2015-12-18 5125
2015-12-19 7046
2015-12-20 3486
2015-12-21 4846
2015-12-22 4220
2015-12-23 3837
2015-12-24 4430
2015-12-25 4037
2015-12-26 5010
2015-12-27 3679
2015-12-28 4145