FrankSc wrote:
Hello,
If you wish to use custom tables in the report builder, you can add the table in the XML file that you can find in C:\Program Files (x86)\Lansweeper\Website\App_Data on your Lansweeper.
Only the objects listed in that XML can be used in reports.
Do note that this XML could be overwritten/modified with an update of the application.
Hello,
I had a similar question and came to this post.
I tried modifying the xml file by adding the following code above the <\metadata>, but after adding it, I'm receiving an error when I want to create or modify a report.
<database name="AccessManagement">
<schema name="dbo" default="True">
<table name="ACL_Folder">
<field name="id" type_name="nvarchar" type="String" size="max" />
<field name="Path" type_name="nvarchar" type="String" size="max" />
<field name="DataOwner" type_name="nvarchar" type="String" size="max" />
<field name="Groupname" type_name="nvarchar" type="String" size="max" />
<field name="Inheritance" type_name="nvarchar" type="String" size="max" />
<field name="IsInherited" type_name="nvarchar" type="String" size="max" />
<field name="AccessControlType" type_name="nvarchar" type="String" size="max" />
<field name="FileSystemRights" type_name="nvarchar" type="String" size="max" />
<field name="PropagationRights" type_name="nvarchar" type="String" size="max" />
<field name="timestamp" type_name="nvarchar" type="String" size="max" />
</table>
</schema>
</database>
The error that I receive is : "startIndex cannot be larger than length of string. Parameter name: startIndex"
