Wednesday, February 13, 2013 11:18 AM
I have a report in SCCM , that results in data of a SCCM client like host name, make, model, CPU, RAM etc….some fields that we use. Then there are few dashboards that are created using this data, in SRS, kind of graphical repesentation for business. Now I have task at hand, to include Work Group/Unix servers information as well into these dashboards. As SCCM doesnt manage them we plan to add their data manually. I am thinking of below to achieve this, but appreciate your comments/suggestions, either in general or from past experience of similar executions
- Create a temp table, which takes all values from “all in one” reports (then automate to update this temp table on some frequency)
- Enable customer with some forms or “Import wizard of SQL” to load data of Unix/WG machines, into above table, which will fill exactly same fields that I need for report.
- Modify SRS dashboard a bit to represent new category etc.
2# Point seems crux and looking for real suggestions here on what tools best suits and stuff like that. Do you recommend Excel or any other HTA kind of tools to enter data into specified SQL Table
Wednesday, February 13, 2013 2:03 PMHi, As long as you are able to get as Dataset into SSRS - then you will be able to display the data in whatever format you want.
Please Mark posts as answers or helpful so that others can more easily find the answers they seek.
Tuesday, March 05, 2013 2:36 PM
I did use using SQL Import Wizard and used a flat file option (.csv file). Then created a SSIS package as well for automation and for consistency purposes. So our customer uses that CSV file to keep it updated and then runs SSIS package that will udpate the table in SQL DB with that static data