| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 20/08/2008 10:23:36
|
andrewl94133
Super SysAider
Joined: 18/06/2008
Messages: 72
Offline
|
Is there a way to retain user information in the database, but still remove the user so the user does not use an end user license?
Say for example a user leaves the company - they can't log any more tickets. Disabling the account seems to make no difference to the user count. Deleting them works, but then if you run a report, say by company or division, they don't appear.
With a high turnover of users, the list will become VERY long, and expensive as well.
|
|
|
21/08/2008 02:55:47
|
shay
SysAid Customer Relations
Joined: 14/04/2008
Messages: 93
Offline
|
Dear andrewl94133
You can disable as many users as needed.
Foe example,if your licrnse at the moment contain 120 end users , and you have more them 1000 end users disabeld ,you will be able to run the requested report and thos users will appeare correctly .
Please let us know if that answers your question. If not, or you need further assistance, please don't hesitate to contact us. Your response will be highly appreciated.
|
|
|
21/08/2008 05:21:30
|
andrewl94133
Super SysAider
Joined: 18/06/2008
Messages: 72
Offline
|
Thanks. Two more questions:
1. How do we see how many Active users there are? The count in the user configuration window only seems to show the number of users defined - thus we don't know if we are running close to the limit.
2. Can SysAid automatically mark users as disabled if they were imported from a previous LDAP import, but are no longer in the LDAP source? So if Joe Bloggs is imported from LDAP, then later deleted, he will not be included in the next ldap refresh. I would like him to automatically be disabled - is that possible?
|
|
|
21/08/2008 08:44:34
|
Rolf
SysAider
Joined: 08/08/2008
Messages: 8
Offline
|
Hello Andrew,
1. Create a filter not to display 'disabled' users
2. I don't think SysAid has functionality to disable deleted users from AD
Thank you,
|
|
|
21/08/2008 11:53:47
|
andrewl94133
Super SysAider
Joined: 18/06/2008
Messages: 72
Offline
|
Here is a vbScript that will check the users in Sysaid against your Active Directory domain, and list active users who are in Sysaid that are not in AD (in other words they've left). It's fairly rough-n-ready but works. First note: run it from a command prompt with the following syntax:
cscript //nologo CheckSysaidUsers.vbs
put "> file.txt" on the end to redirect output to a text file. You could then use a mailer like blat to send the email to an address.
Let me know if you want more info. I might set up a more advanced version that will disable the users automatically, except those listed in an exceptions file (e.g. manually created users not in the AD domain). If there's interest I'll post it once done.
| Filename |
CheckSysaidUsers.vbs |
|
| Description |
VBScript to compare sysaid to AD |
| Filesize |
2 Kbytes
|
| Downloaded: |
13 time(s) |
|
|
|
21/08/2008 12:01:24
|
andrewl94133
Super SysAider
Joined: 18/06/2008
Messages: 72
Offline
|
I forgot to generify the script 
Change AD_DOMAIN to the distinguished name of your own domain. Change the Server name on line 12 to your own SQL server name (I also forgot to mention we have SQL server not the integrated database - I don't know how to connect to that, does it support scripted connections via ADO?)
Also I had been playing around with the line, line 12 should read:
objSQL.ConnectionString = "Driver={SQL Native Client};Server=<your_server_name>;Database=ilient;Trusted_Connection=yes;"
Comments welcome.
|
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
