Skip to Content
author's profile photo Tom Du
0
Tom Du
Jun 24, 2015 at 06:43 AM

Using VBScript - How to retrieve SI_USERGROUPS, SI_LASTLOGONTIME, SI_DISABLED & SI_FORCE_PASSWORD_CHANGE

176 Views

I'm trying to retrieve these SI_USERGROUPS, SI_DISABLED, SI_FORCE_PASSWORD_CHANGE, SI_LASTLOGONTIME, fields along with the rest of the other fields in below query with VBScript so that I can create a .CSV flat file output containing each user information along with each group s/he belonged to (one line per group). So far no such luck. Since I'm not very good with all the object's Properties stuff any help or pointer will be greatly appreciate it.

Set myUsers = iStore.Query("SELECT TOP 1000000 SI_NAME, SI_USERFULLNAME, SI_EMAIL_ADDRESS, SI_USERGROUPS, SI_ALIASES, SI_FORCE_PASSWORD_CHANGE, SI_DESCRIPTION, SI_LASTLOGONTIME, SI_CREATION_TIME, SI_PASSWORDEXPIRE FROM CI_SYSTEMOBJECTS Where SI_KIND='User' and SI_USERFULLNAME != '' ")


In the For... Next loop, I can get three fields but the rest have no clues.

For Each UserItem In myUsers

UserItem.Title

UserItem.FullName

UserItem.EmailAddress

UserItem.??? for Group(s)

UserItem.??? for Disabled

UserItem.??? for Force password change or never login

UserItem.??? for Last Logon Time

UserItem.??? for Create Date

Next

Secondly, where can I find the information about the rest of the Properties for such UserItem.??? above? In another word, how do I know that UserItem.Title is pseudo name for SI_NAME and so on?

Thank you in advance for your help.

Tom