Other OrgID info not showing in tables

q155344 asked a question.

May 22, 2019 at 7:00 AM

So I was running the following query

select l.FullName, l.Email, l.Location, c.HostName, x.Name from SnowLicenseManager.dbo.tblUserInfo l

inner join SnowLicenseManager.dbo.tblComputerUsers k on l.UserID = k.UserID

inner join SnowLicenseManager.dbo.tblComputer c on k.ComputerID = c.ComputerID

inner join SnowLicenseManager.dbo.tblComputerApplications a on c.ComputerID =a.ComputerID

inner join SnowLicenseManager.dbo.tblApplication x on a.ApplicationID = x.ApplicationID

where x.Name like 'ActivePerl 5' and k.MostFrequent = 1

I thought all was well until I realized that this was only pulling info for the main OrgID. For example we have Org123 and Org123/Dev.

Anyone know why these tables are only pulling data for the one OrgID?

SamuelBaughan
7 years ago
You mean that the OrgChecksum for all users is simply the one of your ROOT node? I just added the l.OrgChecksum to your query as follows select l.FullName, l.Email, l.Location, c.HostName, x.Name, l.OrgChecksum from SnowLicenseManager.dbo.tblUserInfo l inner join SnowLicenseManager.dbo.tblComputerUsers k on l.UserID = k.UserID inner join SnowLicenseManager.dbo.tblComputer c on k.ComputerID = c.ComputerID inner join SnowLicenseManager.dbo.tblComputerApplications a on c.ComputerID =a.ComputerID inner join SnowLicenseManager.dbo.tblApplication x on a.ApplicationID = x.ApplicationID where x.Name like 'ActivePerl 5' and k.MostFrequent = 1 And I get results from several Organization nodes: Could it be that all your users are attached to the root node? Or do you mean that the computer data returned is only for the ROOT node?
Expand Post
- q155344
  7 years ago
  I get results from several Organization nodes but for some reason it is not pulling the Dev node. When I am in the SLM GUI I can see the dev nodes consuming licenses so it is quite odd that I cant see them in the back end.
  Expand Post
carolai
7 years ago
Hi Andrew I just can not test it, and send a SQL. Only an idea. Is it possible that your computers in Dev do not have a user? You only used inner joins. So when there is no computeruser then you will not get results. Perhaps it may help to use an outer join when you join tblcomputer and tblcomputerusers and for that test then remove the condition mostfrequent =1 Then you can check if all computers with Activeperl5 should be listed
Expand Post
- q155344
  7 years ago
  Solution found. The computers in Dev did have users but none of those computers have primary users. Removing mostfrequent=1 fixed it. Cant believe I didn't think to check that. Thanks again
  Expand Post

Other OrgID info not showing in tables