Data Dictionary in Use

From support-works
Revision as of 10:46, 21 June 2018 by Pamelal (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search



Status: Published
Version: 1.0
Authors: Hornbill Support
Applies to: Supportworks all ITSMs

If you wish to find out which Data Dictionary is being used by which Analysts you can check either the Database or you can run the System Diagnostics and they will tell you which analysts are using which data dictionaries.

1. DATABASE SEARCH

There is a table that stores analyst data but it is not in the Swdata database but in the Sw_systemdb database in table Swanalysts. In order to view the contents use Interactive SQL:

Use sw_systemdb;

select analystid, name, datadictionary from swanalysts order by datadictionary;

This command will show the analyst names against the data dictionaries.


2. SYSTEM DIAGNOSTICS

In the absence of database access, you can still view which data dictionaries are being used by which analysts when you generate the System Diagnostics report.

If you access Supportworks client and go to Administration > Generate System Diagnostics Report, once you generate the system diagnostics, check the \diags\SwServerService_stats.txt file. Initially you will see the server statistics but as you scroll further down, there is a section called Active Sessions. This will show you the Analyst name and the Current Data Dictionary they are using at the time the System Diagnostics were generated.