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 )
FROM DYNAMICS.dbo.SY01400
GROUP BY USRCLASS
HAVING ( COUNT(USERID) > 0 )
Comments
Post a Comment