Use these step to test your Data source

Launch Internet Explorer http://server name/Reports and select the Data Source. Double click the data source icon or the GUID; highlighted above.

Select Test Connection.

Notice the Successful connection message.

When a SSRS report is created a data source (DS) is used to create and test the report. This DS may not exist on your SSRS site therefore you will need to point it to a DS that does exist on your site. Use these steps to re-point the DS to an existing DS.

· Connect to your SSRS site

· Browse to the appropriate folder

· Click the report you want to change data source for

· Click the Properties tab

· Click the Data Sources link on the left

· Click the Browse button

· Expand Home | <Your SSRS folder name> until you find the shared data source you are looking for

· Select the data source

Note: {5C6358F2-4BB6-4a1b-A16E-8D96795D8602} is the default ConfigMgr data source

· Click OK (You might need to scroll down to see the OK button.)

· Click Apply button

· Click the View tab to ensure that that report works correctly.

How can I create a report using a SQL query provided by Enhansoft or that I find on a blog. (Like the personal blog of Garth Jones, the Chief Architect of Enhansoft.)

· Within the ConfigMgr Console, Browse to Site Database | Computer Management | Reporting | Reports

· In the left pane, right click the Reports node

· Point to New

· Click Report

· In the New Report Wizard, fill in details for:

o Report name

o Category

· Click Edit SQL statement…

· Remove contents of the SQL statement: text box

· Paste the query provided into the SQL Statement:

· Click OK

· On the Display window, click Next >

· On the Links window, click Next >

· On the Security window, click Next >

· On the Wizard Complete window, click Close

You want to update your Office 2007 reports but before you do that you want to delete the existing reports. For example:

Use these steps to delete the folder and it contents.

- Connect to your SSRS site

- Browser to the appropriate folder

- Click the Properties tab

- Click the Delete button

- Click OK to confirm you want to delete the SSRS report.

Notice that the Office 2007 Folder has been removed.

- Connect to your SSRS site

- Browse to the appropriate folder

- Click Upload File

- Click Browse… , select the appropriate file, then click Open

- Click the Overwrite item if it exists check box

- Click OK

- Click the uploaded report

- View results

- Connect to your SSRS site

- Browse to the appropriate folder

- Click the Report you want to delete

- Click the Properties tab

- Click the Delete button

- Click OK to confirm you want to delete the SSRS report.

There are a few reasons why you would want to clean out the monitor data that exists on a PC, for example monitor data included with the imaging process and falsely marked as active monitors.

With all version of the Windows there is no built-in way to clean up monitor data. Therefore these manual steps are needed to fix this issue.

Before beginning download and install Subinacl.exe .

Open an elevated command prompt and execute the following command.

subinacl /subkeyreg HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\DISPLAY /grant=<Domain>\<User Name>=f

Open Regedit, and browse to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\DISPLAY

Delete the Display key.

It is important to reboot the PC at this time. This will allow the OS to recreate the display key with the appropriate data and to reset the security on the registry key.

The ConfigMgr Documentation script has been updated again.

One of the key items in this versions is fixing this error “Microsoft Cursor Engine: Multiple-step operation generated errors. Check each status value.” This error will generally show up when you have comment greater than 500 characters in length. If you get this error please let me know.

If you have any comments, questions or additions that you would like, please post those to the support forum

History

'1.18 - Increased MaxCharacters 500 to fix Microsoft Cursor Engine: Multiple-step operation generated errors. Check each status value. issue.

'1.17 - Made sure that all vars are declared, added ECStr Function, update some of the debug code

'1.16 - Fixed anther issue with username and password. Add more debug mode code

'1.15 - Fixed issue with username and password.

'1.14 - Re-released

'1.13 - Fixed typos Thanks to Jim Dempsey for finding them

'1.12 - Add lots of conversion details such as 1/0 to True/False etc.

'1.11 - Added site control file refresh

'1.10 - Fully Add schedule token decode and update

'1.09 - Added bit shifting functions

'1.08 - Add Decodetext schedule Token

'1.07 - Add Decodetext Function

'1.06 - Add Boundary, Agent setting (HW, SW, etc.)

'1.05 - Add Help, Added Command line options

'1.04 - Changed Default Font size from 12 to 10

'1.03 - Removed SQL Query for Web report, Added ReportID

'1.02 - Fixed Basic site info

'==========================================================

http://www.enhansoft.com/pages/downloads.aspx

Today a newly, posted support topic was published on the Enhansoft wiki, this is the first of many support topic to be published.

How to remotely connect to a PC's WMI

Over the coming months watch for other topics such as:

• How to remove excess monitor data
• How imaging can provide excess monitor data
• Web reports Troubleshooting