Switch port alias & Desk No. Match / Not Match Report

[MDahitule]

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

[Esben_D]

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 )