...
The results of this query should be a table like this:
| ProjectID | Name | LastScannedAt | ProjectState |
|---|---|---|---|
| 1 | TestProject | 2018-01-01 10:54:00.000 | Deleted |
| 2 | Lan01 | 2018-02-01 09:02:00.00 | Running |
| 3 | DataCenter | 2018-02-03 11:32:00.00 | Paused |
The ProjectID is the key, a unique number that identifies the project; This is the value we will use to plug in to other queries to filter by project.
...