How To: Retrieve NP360 Client License Information
Description
If needed, it may be necessary to provide a team member with the NP360 users/license information for a particular client.
Steps:
Run the following query on the client's PROD SQL DB:
SELECT
u.UserName,
u.FullName,
u.Restriction,
u.UserGroup,
u.Active,
MAX(ISNULL(s.Loggedin, sh.LoggedIn)) AS LatestLogin
FROM Users u
LEFT JOIN Session s
ON u.UserName = s.[User]
LEFT JOIN SessionHistory sh
ON u.UserName = sh.[User]
GROUP BY
u.Active,
u.UserName,
u.FullName,
u.Restriction,
u.UserGroup
ORDER BY Active desc,Restriction;
Create a new tab in the shared spreadsheet with the query results and the client/QTR/Year:
CS Quarterly License Reviewe