FAQ:Data Dictionary in Use: Difference between revisions
(Created page with "{{Template:Basic Cover | title=Data Dictionary in Use | type=FAQ }} {{Template:Basic Status | status=Published | version=1.0 | authors=Hornbill Support | applicableto=Support...") |
No edit summary |
||
| Line 17: | Line 17: | ||
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: | 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: | ||
<pre> | |||
Use sw_systemdb; | Use sw_systemdb; | ||
select analystid, name, datadictionary from swanalysts order by datadictionary; | select analystid, name, datadictionary from swanalysts order by datadictionary; | ||
</pre> | |||
This command will show the analyst names against the data dictionaries. | This command will show the analyst names against the data dictionaries. | ||
Revision as of 10:44, 21 June 2018
| Status: | Published |
|---|---|
| Version: | 1.0 |
| Authors: | Hornbill Support |
| Applies to: | Supportworks ITSM 4.x |
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.