2 Replies Latest reply on Jul 17, 2009 2:33 AM by aparker

    list of users

    Paul.Trewin Rookie
    Paul.Trewin Jul 16, 2009 9:23 AM

      Hello

       

      I am using LanDeskServicedesk 7.2.3

       

      Could someone advise me on how to generate a report of already imported and active users.

      ( Active users are the users you would see listed by selecting the following options:  Administration - Then from the user User Management pane - Expand users and then end users)

       

      I know how ro produce a report of users in active directory - but I would like the above report so that I can compare them and identify users who are no longer in AD but are still retained in service desk

       

      Thanks in Advance - Paul Trewin

        • 1. Re: list of users
          Apprentice
          dgaughran Jul 17, 2009 2:10 AM (in response to Paul.Trewin)

          hi Paul,

           

          we are currently on 7.2.6 but can retrieve this data with the following script using sql 2005 as our platform but similar can be used no matter what reporting tool you might have

           

           

           

          select

           

          * from tps_user

          where

           

          tps_user_type_guid = (select tps_guid from tps_user_type where tps_name = 'EndUser')

          and

           

          tps_deleted = 0

           

          note that the * will retun all records and you will need to be specific about the field that you use that contains your End users names.

          rgds,

          Dave Gaughran

           

           

           

           

           

          • 2. Re: list of users
            aparker Employee
            aparker Jul 17, 2009 2:33 AM (in response to dgaughran)

            This should be able to be done using the query tool in product rather than SQL. Just remember to tick the show delete flag when building the query.

             

            Andy