Query to resolve ITSearch shares push on Enterprise Reporter 3.5 (4370273)

Query to resolve ITSearch shares push on Enterprise Reporter 3.5

ITSearch push on Enterprise Reporter 3.5 fails at Initializing due to ambiguous column name when pushing Shares.

ITSearch push on Enterprise Reporter 3.5 fails at Initializing due to ambiguous column name when pushing Shares.

Run the attached SQL query on the Enterprise Reporter's 3.5 database:

Steps:

1. Ensure there are no discoveries running
2. Open SQL Server Management Studio and connect to the server where the ER database is hosted
3. Expand databases
4. Right click the ER 3.5 database and select New query
5. Paste the contents of the 'Alter GetITSearchShares.sql' file (attached to this KB) into the query window and click Execute

Alter GetITSearchShares.zip

Alter GetITSearchShares

NOTE: The information in the script(s) provided is known to work successfully; however, they have not been officially tested by our Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by our Support and Development. Support and Development recommend always making a backup of the current database prior to execution of any script(s) that may modify it. For customization of the Enterprise Reporter, please contact our Professional Services Organization.