Microsoft Dynamics GP - How many user in each user class

SQL Query : To know how many GP user in each user class

 Work for Microsoft Dynamics GP all versions


SELECT USRCLASS, COUNT(USERID) USERID_Count
FROM DYNAMICS.dbo.SY01400
GROUP BY USRCLASS
HAVING ( COUNT(USERID) > 0 )

Comments

Popular Posts