Providing Exported Database information with Headers in an Excel Sheet (File Access Manager)

Providing Exported Database information with Headers in an Excel Sheet (File Access Manager)

This article is to assist you with providing a clear export of data from the database to an excel sheet should our Support or Professional Services Department request this information.

 

This makes it much easier for data to be evaluated properly and potentially migrated into our internal labs. This is why this is requested specifically in this format.

 

Please note you will need at least READ ACCESS to your database to complete the below tasks. Additionally, please consult your internal DBA for further assistance.

 

Enabling The Copy with Headers Option

  1. Navigate to your File Access Manager (SecurityIQ) Database.
  2. Open Microsoft SQL Server Management Studio.
  3. Click Tools > Select Options.
    • ss1.png
  4. In the left Menu bar (inside the Options Menu popup window) click Query Results > SQL Server > Results Grid.
  5. Ensure the "Include column headers when copying or saving the results" option IS enabled and click OK.
    • ss2.png

 

Copying and Saving the Queried Data

From the results of your query…

  1. Click the empty box to the left of "id" and just above "1" to highlight all the results of the query. Alternatively, you can right-click > select all.
  2. Right Click > select Copy with Headers
    • ss3.png
  3. Open Excel and select the 1A Box in a new workbook.
  4. Right Click > select Paste.
    • ss4.png
  5. Expect results in the proper format. 
    • ss5.png

 

From there, your data should be separated properly into rows and columns. As mentioned above, this makes it much easier for data to be evaluated properly and potentially migrated into our internal labs. This is why this is requested specify in this format.

Version history
Revision #:
5 of 5
Last update:
‎Oct 07, 2019 12:26 PM
Updated by:
 
Contributors