MSRDC plugin invalid query

[ydkhatri]

It seems an update to Microsoft Remote Desktop may have broken the query. In the current sqlite db, there does not appear to be any link between tables ZBOOKMARKENTITY and ZCONNECTIONTIMEENTITY.

@mnrkbys This query is now invalid.

mac_apt/plugins/msrdc.py

Line 125 in a6286a1

query = """SELECT ZSTARTTIME, ZMINUTESCONNECTED,

[mnrkbys]

That's right.
I checked with Windows App 11.0.6 (2417) and it appears that ZCONNECTIONTIMEENTITY is no longer used.
However, no alternative data seems to be stored.
This query returns nothing, but also does not generate an error when the plugin is run.
I don't think any code modification is necessary.

[mnrkbys]

I have noticed that there is a column called ZCONNECTIONCOUNT in ZBOOKMARKENTITY.
This value indicates the number of times a connection was made to the computer.
It might be a good idea to add it to the plugin's results.