Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cajos
  • Order by date
  1. cajos

    Find a last used date

    Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'userid'. Server: Msg 207, Level 16, State 1, Line 1 Invalid column name 'userid'. After rebuild SELECT u.UserName, a.pk_appnameid, MAX( s.[SESSIONEND] ) AS last_use FROM [LU_USER] u JOIN SDB_SESSION s ON u.userid =...
  2. cajos

    Find a last used date

    Dear Repliers, After cracking my brain on your statement. I have to conclude that it is not right. I will find all dates before 60 day's.That does not exclude the dates after 60 day's. I Want to find the last DATE a USER used an APPLICATION. And IF this date is older then "let's say&quot...
  3. cajos

    Find a last used date

    SQLBILL Thanks, but your script is generating Error in the fist line. could it have something to do with the aliases u use.
  4. cajos

    Find a last used date

    Works fine I can find all last dates and user names. Only thing missing is the application name.
  5. cajos

    Find a last used date

    Hi I'm an system admin and not a SQL expert. On our Citrix environment I want to find the last date an application is used. In the Citrix SQL database I have found the following tables. APP AppName APPID Acrobat 1 Word 2 Outlook 3 ,, User UserName UserID Peter...
  6. cajos

    Is it me or are printers a pain in Citrix?

    Hi, I like to correct some statements made in this mail thread. Printers can be a pain in the .. if you don't follow the rules: *Make sure that printers updating the Citrix server update with compatable drivers so no 98 ---> 2000 or even NT ---> 2000. (This causes the printer spooler to crash)...

Part and Inventory Search

Back
Top