User Data showing in SLM database but not in UI

q155344 asked a question.

May 2, 2019 at 7:00 AM

For a while now we have not been able to see user data in snow license manager. I recently over the past few weeks got access to the back end. When digging through the database I can see all of my users data being stored here [SnowLicenseManager.dbo.tblUserInfo] The problem I am facing is that this data is not in the users tab of SLM. I am fairly new to snow and have no clue how this could be the case. Could anyone provide some insight on what could be causing this and if there is a solution anyone can think of.

SamuelBaughan
7 years ago
Hi Andrew, The user data from SLM is based on the table called tblUser. This table features a UserID field that can be used to JOIN on the table tblUserInfo. So a suggestion is to try the following query and see if your users appear in the result: SELECT * FROM tblUser tu RIGHT JOIN tblUserInfo ti ON ti.UserID = tu.UserID Then you can check if for some reason, the users are in an OU to which you do not have access (see the OrgChecksum field and JOIN it on tblOrganization to get the OU name)
Expand Post
- q155344
  7 years ago
  When running that query The users do appear in the result from that query. I can see the users Full Name when I run the query yet the Full Name Column in snow is completely empty. I am at a loss as to why this could be.
  Expand Post
  - SamuelBaughan
    7 years ago
    In those circumstances, I suggest creating a ticket. Provide the logs for the DUJ. The quesry they usually ask for is the following one: SELECT * FROM msdb.dbo.sysjobhistory WHERE sql_severity > 0 order by run_date desc, run_time desc SELECT * FROM SnowLicenseManager.dbo.tblErrorLog SELECT * FROM SnowLicenseManager.dbo.tblCIDDataSource SELECT * FROM SnowLicenseManager.dbo.tblInventoryDatabaseLog SELECT * FROM SnowInventory.inv.DbVersionHistory Also, make sure you give the full detail of the versions of SLM and Inventory you are using. This might save you a few days in processing your ticket.
    Expand Post
alexander_bu
7 years ago
Hi Andrew, I had the same issue a while ago not only with users but with datacenters as well. Did you change your organisational structure recently? I noticed that in the SLM database both users and datacenters still had old OrgChecksum values attributed to them that did not exist anymore in the actual org structure. Somehow these changes made were not applied to all inventory objects. So I re-implemented assignment rules for my OUs; after that the appropriate OrgChecksum were applied to users and datacenters, and the objects reappeared in the WebUI. Hope this helps. Best, Alex
Expand Post

User Data showing in SLM database but not in UI