relations for tsysIPRangeCredentials

[Xalyf]

I'm making a report. Searching for IP ranges that don't have assigned credentials. AND searching for assigned credentials for non-existent IP ranges. I can't find the tables associated with tsysIPRangeCredentials to retrieve the necessary data. Can you help me find the tables that store IP ranges for tsysIPRangeCredentials?

[DavidPK]

Hi,

In a Lansweeper Classic installation:

IP range definitions are stored in:
tsysIPScanRanges
This table holds:
The range ID (primary key)
Start and end of the range (IPFrom, IPTo)
Description, enabled flag, schedule, etc.
Credential mappings per IP range are stored in:
tsysIPRangeCredentials
This table holds:
RangeID → foreign key to tsysIPScanRanges.ID
CredentialID (or similar) → foreign key to tsysCredentials
Credentials themselves are stored in:
tsysCredentials