How to create a Dashboard from a query

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

How to create a Dashboard from a query

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> How to create a Dashboard from a query

Page: [1]

Message

<< Older Topic Newer Topic >>

How to create a Dashboard from a query - 12/2/2008 2:21:27 PM

kaskansas

Posts: 7
Score: 0
Joined: 10/15/2008
Status: offline

Hello,
I was wondering how to create a dashboard for an executive from a query that I built in CCM2007.
More specifically how to create a Report from a query. I have tried to copy the WQL code in to the report SQL code area and surprisingly enough it does not work.
Can someone tell me if it is even possible to do such a thing?

Post #: 1

RE: How to create a Dashboard from a query - 12/2/2008 5:19:02 PM

skissinger

Posts: 2293
Score: 145
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline

Yes, it's possible. What's your query?

Also, if memory serves, a dashboard report can't have prompts--it needs to be able to just run without inputs.

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
My Blog
Microsoft MVP - ConfigMgr

(in reply to kaskansas)

Post #: 2

RE: How to create a Dashboard from a query - 12/3/2008 5:33:39 AM

Tom_Watson

Posts: 126
Score: 10
Joined: 9/13/2006
Status: offline

I used these articles to get me started:-

Creating SMS Web Reports from SMS Queries
http://www.myitforum.com/articles/8/view.asp?id=9962 or
http://myitforum.com/cs2/blogs/bleary/archive/2007/03/12/download-creating-sms-web-reports-from-sms-queries.aspx

They were written for SMS, but apply to ConfigMgr as well.

But to be honest, after a while, you'll probably develop enough skills to take a simple query, and write it as a report. Or even go straight to a report, without doing an initial query at all.

Tom

(in reply to skissinger)

Post #: 3

RE: How to create a Dashboard from a query - 12/3/2008 10:42:29 AM

rbennett806

Posts: 885
Score: 18
Joined: 6/14/2006
Status: offline

Sherry is right, Dashboards don't allow prompts. Honestly, in my opinion they're pretty useless. For management you're probably better off coding a separate standalone .HTML page that has hyperlinks to your SCCM reports. That way you can accurately describe the report and what it does before they click on it.

I think Microsoft needs to revisit their reports from a management usage perspective...

(in reply to Tom_Watson)

Post #: 4

RE: How to create a Dashboard from a query - 12/3/2008 10:44:30 AM

jnelson993

Posts: 959
Score: 132
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

I agree. Though, to be fair, in SCCM 2007 R2, they certainly give you the flexibility to do a lot more using Reporting Services. You can build whatever the heck you want with that and have lots of delivery options (like email)

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to rbennett806)

Post #: 5

RE: How to create a Dashboard from a query - 12/3/2008 11:54:36 AM

kaskansas

Posts: 7
Score: 0
Joined: 10/15/2008
Status: offline

Thanks for everyones response. I have read the documentation from Tom's post and have found it quite informative.

Thanks again!

(in reply to jnelson993)

Post #: 6