Listing Citrix / Xenapp clients with specific version with a specified timeframe

I’ve been trying to monitor that all the stray citrix client installations in our firm have gotten upgraded. I have WIRM installed but as it hasn’t been udated for a while and does not have this specific functionality (which the citrix’s own reporting also fails to produce), I digged around the WIRM code to see how it queries the database. This is my modified version of WIRMs query that does the trick well enough.

use [swsummary];
SELECT DISTINCT LU_CLIENT.CLIENTNAME, LU_CLIENT.CLIENTADDRESS
-- SDB_SESSION.SESSIONSTART AS SESSIONSTART, SDB_SESSION.SESSIONEND AS SESSIONEND,
-- SDB_SESSION.DURATION, SDB_SESSION.SESSIONID, SDB_SESSION.TOTALTIMESUM, SDB_SESSION.ACTIVETIMESUM,
-- SDB_SESSION.CPUTIMESUM, SDB_SESSION.MEMORYSUM, LU_USER.USERNAME, LU_SERVERNAME.SERVERNAME, LU_APPNAME.APPNAME,
-- LU_CLIENT.CLIENTNAME, LU_CLIENT.CLIENTADDRESS, SDB_SESSION.PK_SDB_SESSIONID, LU_CLIENTPROPERTIES.BUILD,
-- LU_CLIENTPROPERTIES.VERSION, SDB_CLIENTHISTORY.USINGSG, LU_CLIENTTYPEMAPPINGS.CLIENTTYPENAME, LU_LAUNCHER.LAUNCHER
FROM LU_CLIENTPROPERTIES
INNER JOIN SDB_CLIENTHISTORY ON LU_CLIENTPROPERTIES.PK_CLIENTPROPERTIESID = SDB_CLIENTHISTORY.FK_CLIENTPROPERTIESID
--INNER JOIN LU_CLIENTTYPEMAPPINGS ON LU_CLIENTPROPERTIES.FK_CLIENTTYPEID = LU_CLIENTTYPEMAPPINGS.PK_CLIENTTYPEID
--INNER JOIN LU_LAUNCHER ON SDB_CLIENTHISTORY.FK_LAUNCHERID = LU_LAUNCHER.PK_LAUNCHERID
RIGHT OUTER JOIN SDB_SESSION
--INNER JOIN LU_USER ON SDB_SESSION.FK_USERID = LU_USER.PK_USERID
--INNER JOIN LU_SERVER ON SDB_SESSION.FK_SERVERID = LU_SERVER.PK_SERVERID
--INNER JOIN LU_SERVERNAME ON LU_SERVER.FK_SERVERNAMEID = LU_SERVERNAME.PK_SERVERNAMEID
INNER JOIN LU_CLIENT ON SDB_SESSION.FK_CLIENTID = LU_CLIENT.PK_CLIENTID
--INNER JOIN LU_APPNAME ON SDB_SESSION.FK_APPNAMEID = LU_APPNAME.PK_APPNAMEID
ON SDB_CLIENTHISTORY.FK_SDB_SESSIONID = SDB_SESSION.PK_SDB_SESSIONID
WHERE SDB_SESSION.SESSIONSTART > '2008-11-24 00:01:00' AND LU_CLIENTPROPERTIES.VERSION = '9.00.32649';


Just check that you replace the summary db in the beginning and the times and version on the last row…