Generating SQL Query results and pasting them into Microsoft Excel

Title

Issue

This article will talk about generating the results of a SQL query when requested to by Snow Support. The article will walk you through step by step from executing a script to the process of preparing the query results for Snow Software Support.

As a pre-requisite that before you can follow this guide, you should have the following:

1.Access to the SQL Server where Snow Database is hosted.

2.Permission to execute SQL queries

3.Microsoft Excel installed and accessible

Solution

In our example Snow Support have asked you to provide the query results of the below two queries:

--sheet name as tblErrorLog
SELECT * FROM SnowLicenseManager.dbo.tblErrorLog;

--sheet name as tblJobLog
select * from SnowLicenseManager.dbo.tblJobLog

The sheet name would be the worksheet name we will use in the Excel Sheet. Using the above example, the worksheet name will be tblErrorLog and tblJobLog

Steps to follow:

1.Login to the SQL Server (relating to where your Snow Software database is hosted).
2.Open SQL Management Studio:

3.Login to SQL Server:

4.Click on the New Query button:

5.Next, paste the query that Snow Support have requested that you run:

6. It is recommended to run each individual query individually so as not to clutter the query results, so highlight the first query and hit the Execute button:
Execute query at a time

7.Below the executed query you will see the query results:

NOTE: You have to click the corner left-hand cell (as shown below) in order to highlight all the results

Click to highlight all rows

8.Next, right-click on the same cell and select to Copy with Headers:

9.Open your Microsoft Excel worksheet and paste the copied results:
Paste the query results to Microsoft Excel sheet

10.You should see the results being copied, if the query results were empty (zero rows returned) it will paste just the headers

NOTE: Don't be be concerned if the query results returned nothing (no rows) because it is sometimes a good sign. In this example this would indicate that there are no DUJ errors found for example. Snow Support would still like to know that no results were returned (by pasting the headers).

Query results pasted

11.Next, change the name of the worksheet to what the Support Engineer has described. In this example we will name it as tblErrorLog:
Change the Sheet name

12. Finally follow steps 6 to 11 for all of the other queries to be executed:

13. Save the Excel file and attach it to the Support case via the Snow Support Portal .

Was this helpful?

Support Hub

Deployment type

On-premises;Service Provider Edition (SPE)

Visibility

Guest

URL Name

Generating-SQL-Query-Results-and-Pasting-it-to-Microsoft-Excel

Are you sure you want to cancel the case creation?

Case closed successfully

Action performed successfully

Upload Attachment

Maximum file size allowed is 3 MB.

File type not supported.

Supported file types:

Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)

Are you sure you want to close this case

Get Hotline support

Products	Region	Phone Numbers
FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield	North America *	+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America)
	Europe *	+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe)
	Japan *	+81 3-4540-5335 (select option 2)
	Australia *	+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia)
Usage Intelligence (formerly Revulytics) Compliance Intelligence	Please use the Case Portal to submit your support ticket or reach out to your Revenera contact.

Related Articles

Please wait...

Case id: 00001065