DevTest VMs

Lana Granville 1

Which query can I use to find the start up time of each VM in each DevTest Lab resource group when each VM has their own resource group?

I need to be able to identify which ones aren't being used so they can be removed.

1 answer

Monalla-MSFT 11,801 Reputation points

2020-10-23T15:58:51.12+00:00
Hello @Lana Granville - Thanks for reaching out to us.

We have a script to achieve this. It is not published in our docs yet, but we have a plan to publish in the docs pretty soon.

Attached a script to detect stale DTL virtual machines.

It’s currently using a library that we’re working on (you’ll see the download code for the library at the top of the script).

The script will find any DTL VMs that haven’t had any ‘start’ events (either in compute or DTL) in the past week.

NOTE: if the VM is always running it won’t have start events, the script is assuming you’re using a shutdown schedule but is easy to modify. It also outputs the results (doesn’t delete any VMs) but that’s also something easy to add.

Hope this helps. If the response helped, please "Accept as Answer" and "Upvote" the same

34578-get-vmstartups.txt
Please sign in to rate this answer.
Lana Granville 1 Reputation point

2020-10-23T16:54:43.487+00:00

Thank you so much! Unfortunately I'm not allowed to use the script because of the module reference.

I appreciate you trying to help though :)

Monalla-MSFT 11,801 Reputation points

2020-10-23T17:45:43.943+00:00

@Lana Granville - Thank you for the response. But, Can you elaborate what you meant by Module reference, so we can help you resolve your issue.

Lana Granville 1 Reputation point

2020-10-26T14:08:57.743+00:00

I'm not allowed to use the module from Pete Hauge.

AzDtlModuleSource = "https://raw.githubusercontent.com/petehauge/DTL-VM-Generator/v2-fixes/Az.DevTestLabs2.psm1";

Monalla-MSFT 11,801 Reputation points

2020-10-26T15:33:41.987+00:00

@Lana Granville - Thanks for your response.
Why are you not allowed to use the module from Pete Hauge? Is it against enterprise policy? Or are you just not able to access it?

Lana Granville 1 Reputation point

2020-10-27T18:53:59.38+00:00

When I asked my manager if we could use a script that calls a module she said 'we don't use code like that'. Sorry that's all I know.

Monalla-MSFT 11,801 Reputation points

2020-10-27T22:06:47.423+00:00

It looks like its against your enterprise policy. If that is the case, we don't have this currently published in our PS docs. We have it on our roadmap, but don't have timeline.

Hope this helps.

Lana Granville 1 Reputation point

2020-10-28T20:43:03.847+00:00

I'll look forward to when it's published in the PS docs.

Would you know of a Kusto query that might work in the meantime?

Monalla-MSFT 11,801 Reputation points

2021-02-23T16:30:19.577+00:00

@Lana Granville - Apologies for the delay in response. Please let us know if you are still looking for the Kusto Query and I'll try to get it to you ASAP.

Thank you for your patience.
Sign in to comment