Roles and Permissions revised

NOTE #1 - For new installs the Reporter role has been removed.

NOTE #2 - For new installs the ability to create queries, summaries, users and widgets has been moved from the OrgAdmin to the Admin role.

Neither of the above have been altered for existing (upgraded) installs. It is recommended you change these roles on your installation after checking users will not be affected. Opmantek has not automatically done this as this may cause confusion for users.

These changes were made in an effort to improve and tighten security.

Revised LIKE in URL

Previously if you supplied a URL with an attribute like system.description=LIKEvmware we would process that and add a preceding and trailing %, so we ended up with (in SQL) system.description LIKE '%vmware%'. This has been revised. Now if you provide the same thing (ie, no % symbols) it will function the same as before, but if you put a % anywhere in the attribute value, we will not add preceding and trailing slashes. IE if you provide system.description=LIKEvmware% now you will get the following SQL system.description LIKE 'vmware%' - no preceding % would be added. If you have attribute values like this vm%ware and you were expecting %vm%ware% in SQL, you just need to add your own preceding and trailing % symbols. This may affect any custom items, so if you're seeing different results after upgrading, this could explain it. Please revise any custom items as required. Apologies for any inconvenience this causes, but going forward this allows more flexible and at the same time more accurate queries.