Workstation IP Query

Can someone help me write the following query reports (I have no idea what I'm doing )?
Workstation: IP, Resource Name, Department, Site, MAC Address (sorted by IP)
&
Workstation: MAC Address, Resource Name, Department, Site, IP (sorted by MAC Address)

Thanks,

Nate

• Topic Participants

• nsones

• ServiceDesk Plus

• Andy.Fox