SQL Query request - last Agent contact date with model filter

SQL Query request - last Agent contact date with model filter

HI All,
I'm looking for a SQL query showing a simple column list of:

Machine name
Machine model  (with filter "Latitude")
Service Tag
Asset state (with filter "In use")
Last logged in user
Agent last contact time

Thanks in advance for all your help - your an amazing team! 

                  New to ADSelfService Plus?