Show All Local Drives
Query
// Use Case: List all local drives on this Windows PC
LogicalDriveExplanation
This query is designed to retrieve and display a list of all local drives on a Windows PC. It uses the LogicalDrive table, which contains information about the logical drives available on the system. Essentially, when you run this query, it will provide you with details about each local drive, such as their names and possibly other attributes, depending on the available data in the LogicalDrive table.
Details
Ugur Koc
Released: December 13, 2024
Tables
LogicalDrive
Keywords
LogicalDrive
Operators
projectwheresummarizecountdistincttoporder bylimitjoinunionextendletparseparse-wheremv-expandmv-applyrangemake-seriesbintoscalartobooltodatetimetodoubletointtostringtolongtorealtodecimalformat_datetimeformat_timespandatetime_partdatetime_diffdatetime_addnowagostartofdayendofdaystartofweekendofweekstartofmonthendofmonthstartofyearendofyeardayofweekdayofmonthdayofyearweekofyearmonthofyearyearhourminutesecondiffcasecoalesceisemptyisnotemptyisnullisnotnullisemptystringisnotemptystringisemptyguidisnotemptyguidisemptyarrayisnotemptyarrayisemptyobjectisnotemptyobjectisemptydynamicisnotemptydynamicisemptybinaryisnotemptybinaryisemptydatetimeisnotemptydatetimeisemptytimespanisnotemptytimespanisemptydecimalisnotemptydecimalisemptyrealisnotemptyrealisemptyintisnotemptyintisemptylongisnotemptylongisemptyboolisnotemptyboolisnot