• State Suggested Answer
  • Locked Locked
  • Replies 11 replies
  • Answers 1 answer
  • Subscribers 33 subscribers
  • Views 8277 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Custom report - local admin and local group membership of servers

mohammed.shah
over 7 years ago

Hi guys,

I need to produce a report that used to be present in Quest Reporter (which is now end of life) which checks the local admin and local group membership of servers within our organization.

It would need to exclude system based accounts or the authenticated user accounts so it only captures users and groups that have been added.

 

Is this possible at all within Enterprise Reporter? we are running version 2.5.1 build 200.

 

Many thanks,

 

Mo.

Parents
  • 0 over 6 years ago
    Hi Mo

    We've already got "Members do not end with value" above and the others you requested are going to be similar. Also, as I said above, when we say member we need to be sure that we're talking about just the account name, not the domain name or computer name. If you want to work with the domain and computer name then this can be done separately by replacing "where MA.SAMAccountName" with "MA.SAMAccountDomain" in the examples below.

    Members does not equal
    ... where MA.SAMAccountName not like 'administrator' -- (note: removal of % wildcard character)

    Members does not contain
    ... where MA.SAMAccountName not like '%administrator%' -- (note: addition of % wildcard characters)

    Members does not begin with
    ... where MA.SAMAccountName not like 'administrator%' -- (note: addition of trailing % wildcard character)

    Hope this helps.

    Thanks
    Adam
Reply
  • 0 over 6 years ago
    Hi Mo

    We've already got "Members do not end with value" above and the others you requested are going to be similar. Also, as I said above, when we say member we need to be sure that we're talking about just the account name, not the domain name or computer name. If you want to work with the domain and computer name then this can be done separately by replacing "where MA.SAMAccountName" with "MA.SAMAccountDomain" in the examples below.

    Members does not equal
    ... where MA.SAMAccountName not like 'administrator' -- (note: removal of % wildcard character)

    Members does not contain
    ... where MA.SAMAccountName not like '%administrator%' -- (note: addition of % wildcard characters)

    Members does not begin with
    ... where MA.SAMAccountName not like 'administrator%' -- (note: addition of trailing % wildcard character)

    Hope this helps.

    Thanks
    Adam
Children
No Data