Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-03-2014 04:43 PM
Dear Sirs.
I'm looking for a custom SQL report that will provide the following information to be exported on an excel spreadsheet:
1. Server name
2. SQL version installed
3. serviceName
4. List of Database names on the SQL instance.
Do you know if this is possible?
Thank you so much in advance for your help.
Best regards,
I'm looking for a custom SQL report that will provide the following information to be exported on an excel spreadsheet:
1. Server name
2. SQL version installed
3. serviceName
4. List of Database names on the SQL instance.
Do you know if this is possible?
Thank you so much in advance for your help.
Best regards,
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-14-2014 12:56 PM
You can edit the built-in report "Software: All SQL Server editions".
• Hit the pencil shaped edit button next to the report under Reports/View All Reports.
• Double-click on tblSqlDatabases in the table list on the right to add the table to your report.
• In the visual representation of the report in the upper section of the report builder, tick the Name field in tblSqlDatabases.
• Hit the Save & Run button.
• Hit the pencil shaped edit button next to the report under Reports/View All Reports.
• Double-click on tblSqlDatabases in the table list on the right to add the table to your report.
• In the visual representation of the report in the upper section of the report builder, tick the Name field in tblSqlDatabases.
• Hit the Save & Run button.
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-25-2014 11:28 AM
Perfect.
Thank you so much for your help.
Best Regards,
Thank you so much for your help.
Best Regards,
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-14-2014 12:56 PM
You can edit the built-in report "Software: All SQL Server editions".
• Hit the pencil shaped edit button next to the report under Reports/View All Reports.
• Double-click on tblSqlDatabases in the table list on the right to add the table to your report.
• In the visual representation of the report in the upper section of the report builder, tick the Name field in tblSqlDatabases.
• Hit the Save & Run button.
• Hit the pencil shaped edit button next to the report under Reports/View All Reports.
• Double-click on tblSqlDatabases in the table list on the right to add the table to your report.
• In the visual representation of the report in the upper section of the report builder, tick the Name field in tblSqlDatabases.
• Hit the Save & Run button.