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.
Mail 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 ;
Mail AuthPass SMTP mail server – authentification password
Mail AuthUser SMTP mail server – authentification user
Mail FallBackTo This is the fallback email address if no TO was specified – in some cases
Mail FROM This is the default FROM address for any send emails – when there is no alternate from defined
Mail 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