SysConfig will open a configuration table. This is a system configuration table and will influence any open client right away since it is stored in the SQL database.
There are THREE absolute important configuration settings that are highlighted in ORANGE – the rest is a bit more relative and does not need attention right away.
For developers, the Application\Maintenance value might be interesting if you want to roll out updated versions or kick all users out of the system.
Please see the list below for explanation of all the available config values.
|ParamaterGroup||SubParameterGroup||Explanation and instructions|
|Application||Maintenance||If you set this flag to 1 no one will be able to start the database anymore. Any existing open applications will close within about 4 minutes. This actually is to force everyone out. You should not need to change it. You might need to change this back directly in the table, cause the application will not start as long this flag is set.|
|Application||ReAttach||This flag will force every client to reattach the SQL tables every 2 minutes – you should never need to change this unless you are a developer and do it on purpose. Don’t forget to change it back.|
|Application||SubstractHeight||This is a subtracted height value for the auto-adjustment of the forms. Most forms will actually adjust to your screen resolution automatically. Still, the system was optimized to 24″ monitors. The Main Menu form is one of the forms that will not auto-adjust. There should not be a need to change this.|
|Application||Title||This is the title of the database. Change it to your liking, we had names the The Kraken or Hydra for it – in the end it is up to you.|
|LDAPCompare||Domains||list a DNS like domain name in this field – in theory you can list multiple if you have multiple trusts. For each of those domains there needs to be a new LDAPCompare value like the following|
|LDAPCompare||domain.local||this is the LDAPCompare value that needs to exist for each domain. If you list e.g. “mydomain.local” under “Domains” you will have the SubParameterGroup adjusted to “mydomain.local” instead of “domain.local” what is the example/default. In the end just change the SubParameterGroup value to the domain-name you listed in LDAPCompare\Domains
The ParameterValue should be <servername or domain name>/<OU path> e.g. mydomain.local\DC=mydomain,DC=local
The whole configuration is used for comparing what is in the defined OU-Substructure but not in the IT Asset database – see the button LDAP compare in the Main menu.
|LDAPSync||DomainSyncStartDN||Put the distinguished name of the OU in your domain for which one users, groups and computer should be monitored. This actually will as well import your employees. E.g.: DC=mydomain,DC=local|
|LDAPSync||email_lastsend||Clear the parameter to re-send the email – besides that, field will automatically re-populate when the email was send (every 24h) / to disable the email – set date in the far far future like 12/31/2050 11:59:59 PM – this correlates with email_schedule|
|LDAPSync||email_recipient||recipient address (SMTP) for the LDAP change reports|
|LDAPSync||email_schedule||this is a TIME value – it determines at what time every 24h the LDAP change report is sent out|
|LDAPSync||email_sender||this is the FROM address for the LDAP change report|
|LDAPSync||email_subject||this is the subject line of the LDAP change report email|
|LDAPSync||IntervalInMinutes||put a number in this field – a good start is 30 – what will cause a new LDAP synchronization every 30 minutes|
|LDAPSync||SyncTimeTreshHoldForRemoved||this is a threshold value – 15 minutes above the last sync plus interval in the end. The should be no need to change this.|
|AddressSeparator||By default commas are searched and replaced in the CC field of emails. Use a , here if you want to keep it or and alternate replace character like a ;|
|AuthPass||SMTP mail server – authentification password|
|AuthUser||SMTP mail server – authentification user|
|FallBackTo||This is the fallback email address if no TO was specified – in some cases|
|FROM||This is the default FROM address for any send emails – when there is no alternate from defined|
|SMTPserver||SMTP mail server – application will connect on port 25|
|Main||ExpensesWarning||in days, filter for Expenses coming up soon in Main Menu|
|Main||ServerWarrantyWarning||in days, filter for Warranty ending soon in Main Menu|
|MainForm||VendorIssuesAssigneeOnly||Main Form – Vendor Issues list-box – if “0” then all open Issues will be shown / if <> 0 then only issues assigned to current user will be shown|
|Projects||ProjectTasksImport||0 = leaves the button activate so that imports are always possible / <> 0 will disable the button once at list one item is in the list|
|Projects||RootPath||Root Project folder path – to create new folders|
|Reminder||CCHelpdesk||This is the CC heldpesk email address|
|RESTvmware||DataCenters||Comma separated list of host-names of Vmware systems – cluster name or stand-a-lone hostname – use DNS name! – This is used by the VMware compare function, if you want to use it – this is what you need to configure.|
|SQL||LogonDomain||This is a MUST change value. Put your NetBIOS domain name here – like MYDOMAIN\ including the backslash|
|URL||Dell||URL for Dell service tags – link/url has a [value] part that will put the ServiceTag instead (replace)|
|URL||Helpdesk||Helpdesk link – TicketID will be added at the end of the link|
|URL||POTracking||PO Tracking number – Google search|
|Wiki||ContentPath||Path where the Wiki content resides|
|Wiki||LastCleanup||Automatically increasing date – determines the last cleanup in TempPath – you can set a positive date in the far feature to disable the whole cleanup procedure|
|Wiki||TempPath||Temp path to load/save PDF files for Wiki preview. See Wiki\LastCleanup on how to disable this while setting a future date.
This is where temporary .PDF files will be generated. There is a auto-cleanup in the system that will forcefully remove any file in this path that does not have a current Wiki entry. By default, this means any file. Please set a absolute wrong path if you want to avoid this – if the path set here is accessible, the system will try to clean this folder out.
Note: If you used the C:\temp\ITAssetsDB\WikiTemp from the ZIP file, nothing should happen. Just be aware that you set this path proper. You can even change it later to a central network location – it just cleans out temp file that are not needed any more.
|Application||ErrorLimit||This is an error limit for the users that have the setting NoErrorMessages set – meaning they won”t see a message box – but once this limit is reached they will see a single message box and be kicked out – errors should be still written to the tblErrors.|
|Checklists||Script_AlternateUsername||Depends on Option Script_AlternateUserOption = 4 / this username will be used instead|
|Checklists||Script_AlternateUserOption||1 = use current user / 2 = use current user + Script_AlternateUserSuffix / 3 = user current user + Script_AlternateUserPreffix / 4 = use ScriptAlternateUsername|
|Checklists||Script_AlternateUserPreffix||Depends on Option Script_AlternateUserOption = 3 / this will be set before the current username e.g.: username = jdoe => admin_jdoe|
|Checklists||Script_AlternateUserSuffix||Depends on Option Script_AlternateUserOption = 2 / this will be set after the current username e.g.: username = jdoe => jdoe_admin|
|HistoryReport||email_lastsend||Clear the parameter to re-send the email – besides that, field will automatically re-populate when the email was send (every 24h) / to disable – set date in the far far future like 12/31/2050 11:59:59 PM|
|HistoryReport||email_recipient||TO Address, comma separate if more then one recipient|
|HistoryReport||email_schedule||Time of the day (hh:mm AM/PM or 24 hour format) for when the mail should get send out|
|HistoryReport||email_sender||FROM address field|
|HistoryReport||email_subject||Subject line of the email|
|Main||WorkstationsReplaceInDays||in days – for workstations with a ReplaceOn date less then 30 days away or past the current date|
|Workstations||ReplaceOnAddMonths||number for months to add to purchase date (if set) to set the ReplaceOn field (if empty) on save record event|