cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
MDahitule
Engaged Sweeper II
Hi Team,

We have tagged switch port alias (Description) with our port no. and desk no. i.e. ***LAN PORT-1111A(XX-YYY-ZZ)***. We have custom field (custom02) called DeskNumber i.e. XX-YYY-ZZ.

I need to create report witch will find desk no. from switch port alias and match with DeskNumber. If Desk no. in switch port alias and desk no. in DeskNumber field is Match then report as Match else Not Match.

Can you please help / guide to create the report.

Thanks in Advance.

Regards
Mangesh Dahitule
1 REPLY 1
Esben_D
Lansweeper Employee
Lansweeper Employee
To get you started, you can find the port description in the database field: tblSNMPInfo.IfDescription
Asset custom fields are stored in the table tblAssetCustom.

To get the report to show match or no match I think a case would be best ( https://www.w3schools.com/sql/func_mysql_case.asp )