Query Details
Find Disk Information
Query
Author: Niklas Tinner (@NiklasTinner) Use Case: Show all informations about the physical disks DiskDrive
Explanation
This query is used to display all the details about the physical disks in a system.
Details
Ugur Koc
Released: February 4, 2024
Tables
DiskDrive
Keywords
Physical,Disks
Operators
whereprojectsummarizebycountdistinctavgminmaxsumorder byascdesclimitfilterhas_anyhashasnotinnotincontainsstartswithendswithmatches regexisnullisnotnullisemptyisnotemptyandornotbetweendatetime_diffdatetime_adddatetime_truncdatetime_partdatetime_isowkdatetime_isoyrdatetime_daydatetime_hourdatetime_minutedatetime_seconddatetime_milliseconddatetime_microseconddatetime_nanoseconddatetime_todatetimedatetime_totimeofdaydatetime_todatetimezonedatetime_todurationdatetime_toscalardatetime_fromscalardatetime_parsedatetime_formatdatetime_nowdatetime_utcnowdatetime_addyearsdatetime_addmonthsdatetime_adddaysdatetime_addhoursdatetime_addminutesdatetime_addsecondsdatetime_addmillisecondsdatetime_addmicrosecondsdatetime_addnanosecondsdatetime_subtractyearsdatetime_subtractmonthsdatetime_subtractdaysdatetime_subtracthoursdatetime_subtractminutesdatetime_subtractsecondsdatetime_subtractmillisecondsdatetime_subtractmicrosecondsdatetime_subtractnanosecondsdatetime_diffyearsdatetime_diffmonthsdatetime_diffdaysdatetime_diffhoursdatetime_diffminutesdatetime_diffsecondsdatetime_diffmillisecondsdatetime_diffmicrosecondsdatetime_diffnanosecondsdatetime_truncyeardatetime_truncmonthdatetime_truncdaydatetime_trunchourdatetime_truncminutedatetime_truncseconddatetime_truncmilliseconddatetime_truncmicroseconddatetime_truncnanoseconddatetime_partyeardatetime_partmonthdatetime_partdaydatetime_parthourdatetime_partminutedatetime_partseconddatetime_partmilliseconddatetime_partmicroseconddatetime_partnanoseconddatetime_isowkyeardatetime_isowkmonthdatetime_isowkdaydatetime_isowkhourdatetime_isowkminutedatetime_isowkseconddatetime_isowkmilliseconddatetime_isowkmicroseconddatetime_isowknanoseconddatetime_isoyryeardatetime_isoyrmonthdatetime_isoyrdaydatetime_isoyrhourdatetime_isoyrminutedatetime_isoyrseconddatetime_isoyrmilliseconddatetime_isoyrmicroseconddatetime_isoyrnanoseconddatetime_dayyeardatetime_daymonthdatetime_daydaydatetime_dayhourdatetime_dayminutedatetime_dayseconddatetime_daymilliseconddatetime_daymicroseconddatetime_daynanoseconddatetime_houryeardatetime_hourmonthdatetime_hourdaydatetime_hourhourdatetime_hourminutedatetime_hourseconddatetime_hourmilliseconddatetime_hourmicroseconddatetime_hournanoseconddatetime_minuteyeardatetime_minutemonthdatetime_minutedaydatetime_minutehourdatetime_minuteminutedatetime_minuteseconddatetime_minutemilliseconddatetime_minutemicroseconddatetime_minutenanoseconddatetime_secondyeardatetime_secondmonthdatetime_seconddaydatetime_secondhourdatetime_secondminutedatetime_secondseconddatetime_secondmilliseconddatetime_secondmicroseconddatetime_secondnanoseconddatetime_millisecondyeardatetime_millisecondmonthdatetime_milliseconddaydatetime_millisecondhourdatetime_millisecondminutedatetime_millisecondseconddatetime_millisecondmilliseconddatetime_millisecondmicroseconddatetime_millisecondnanoseconddatetime_microsecondyeardatetime_microsecondmonthdatetime_microseconddaydatetime_microsecondhourdatetime_microsecondminutedatetime_microsecondseconddatetime_microsecondmilliseconddatetime_microsecondmicroseconddatetime_microsecondnanoseconddatetime_nanosecondyeardatetime_nanosecondmonthdatetime_nanoseconddaydatetime_nanosecondhourdatetime_nanosecondminutedatetime_nanosecondseconddatetime_nanosecondmilliseconddatetime_nanosecondmicroseconddatetime_nanosecondnanoseconddatetime_todatetimeyeardatetime_todatetimemonthdatetime_todatedaydatetime_todatetimehourdatetime_todatetimeminutedatetime_todatetimeseconddatetime_todatetimemilliseconddatetime_todatetimemicroseconddatetime_todatetimenanoseconddatetime_totimeofdayhourdatetime_totimeofdayminutedatetime_totimeofdayseconddatetime_totimeofdaymilliseconddatetime_totimeofdaymicroseconddatetime_totimeofdayscalardatetime_todatetimezonescalardatetime_todurationscalardatetime_toscalarscalardatetime_fromscalarscalardatetime_parsescalardatetime_formatscalardatetime_nowscalardatetime_utcnowscalardatetime_addyearsscalardatetime_addmonthsscalardatetime_adddaysscalardatetime_addhoursscalardatetime_addminutesscalardatetime_addsecondsscalardatetime_addmillisecondsscalardatetime_addmicrosecondsscalardatetime_addnanosecondsscalardatetime_subtractyearsscalardatetime_subtractmonthsscalardatetime_subtractdaysscalardatetime_subtracthoursscalardatetime_subtractminutesscalardatetime_subtractsecondsscalardatetime_subtractmillisecondsscalardatetime_subtractmicrosecondsscalardatetime_subtractnanosecondsscalardatetime_diffyearsscalardatetime_diffmonthsscalardatetime_diffdaysscalardatetime_diffhoursscalardatetime_diffminutesscalardatetime_diffsecondsscalardatetime_diffmillisecondsscalardatetime_diffmicrosecondsscalardatetime_diffnanosecondsscalardatetime_truncyearscalardatetime_truncmonthscalardatetime_truncdayscalardatetime_trunchourscalardatetime_truncminutescalardatetime_truncsecondscalardatetime_truncmillisecondscalardatetime_truncmicrosecondscalardatetime_truncnanosecondscalardatetime_partyearscalardatetime_partmonthscalardatetime_partdayscalardatetime_parthourscalardatetime_partminutescalardatetime_partsecondscalardatetime_partmillisecondscalardatetime_partmicrosecondscalardatetime_partnanosecondscalardatetime_isowkyearscalardatetime_isowkmonthscalardatetime_isowkdayscalardatetime_isowkhourscalardatetime_isowkminutescalardatetime_isowksecondscalardatetime_isowkmillisecondscalardatetime_isowkmicrosecondscalardatetime_isowknanosecondscalardatetime_isoyryearscalardatetime_isoyrmonthscalardatetime_isoyrdayscalardatetime_isoyrhourscalardatetime_isoyrminutescalardatetime_isoyrsecondscalardatetime_isoyrmillisecondscalardatetime_isoyrmicrosecondscalardatetime_isoyrnanosecondscalardatetime_dayyearscalardatetime_daymonthscalardatetime_daydayscalardatetime_dayhourscalardatetime_dayminutescalardatetime_daysecondscalardatetime_daymillisecondscalardatetime_daymicrosecondscalardatetime_daynanosecondscalardatetime_houryearscalardatetime_hourmonthscalardatetime_hourdayscalardatetime_hourhourscalardatetime_hourminutescalardatetime_hoursecondscalardatetime_hourmillisecondscalardatetime_hourmicrosecondscalardatetime_hournanosecondscalardatetime_minuteyearscalardatetime_minutemonthscalardatetime_minutedayscalardatetime_minutehourscalardatetime_minuteminutescalardatetime_minutesecondscalardatetime_minutemillisecondscalardatetime_minutemicrosecondscalardatetime_minutenanosecondscalardatetime_secondyearscalardatetime_secondmonthscalardatetime_seconddayscalardatetime_secondhourscalardatetime_secondminutescalardatetime_secondsecondscalardatetime_secondmillisecondscalardatetime_secondmicrosecondscalardatetime_secondnanosecondscalardatetime_millisecondyearscalardatetime_millisecondmonthscalardatetime_milliseconddayscalardatetime_millisecondhourscalardatetime_millisecondminutescalardatetime_millisecondsecondscalardatetime_millisecondmillisecondscalardatetime_millisecondmicrosecondscalardatetime_millisecondnanosecondscalardatetime_microsecondyearscalardatetime_microsecondmonthscalardatetime_microseconddayscalardatetime_microsecondhourscalardatetime_microsecondminutescalardatetime_microsecondsecondscalardatetime_microsecondmillisecondscalardatetime_microsecondmicrosecondscalardatetime_microsecondnanosecondscalardatetime_nanosecondyearscalardatetime_nanosecondmonthscalardatetime_nanoseconddayscalardatetime_nanosecondhourscalardatetime_nanosecondminutescalardatetime_nanosecondsecondscalardatetime_nanosecondmillisecondscalardatetime_nanosecondmicrosecondscalardatetime_nanosecondnanosecondscalardatetime_todatetimeyearscalardatetime_todatetimemonthscalardatetime_todatedayscalardatetime_todatetimehourscalardatetime_todatetimeminutescalardatetime_todatetimesecondscalardatetime_todatetimemillisecondscalardatetime_todatetimemicrosecondscalardatetime_todatetimenanosecondscalardatetime_totimeofdayhourscalardatetime_totimeofdayminutescalardatetime_totimeofdaysecondscalardatetime_totimeofdaymillisecondscalardatetime_totimeofdaymicrosecondscalardatetime_totimeofdayscalardatetime_todatetimezonescalardatetime_todurationscalardatetime_toscalarscalardatetime_fromscalarscalardatetime_parsescalardatetime_formatscalardatetime_nowscalardatetime_utcnowscalardatetime_addyearsscalardatetime_addmonthsscalardatetime_adddaysscalardatetime_addhoursscalardatetime_addminutesscalardatetime_addsecondsscalardatetime_addmillisecondsscalardatetime_addmicrosecondsscalardatetime_addnanosecondsscalardatetime_subtractyearsscalardatetime_subtractmonthsscalardatetime_subtractdaysscalardatetime_subtracthoursscalardatetime_subtractminutesscalardatetime_subtractsecondsscalardatetime_subtractmillisecondsscalardatetime_subtractmicrosecondsscalardatetime_subtractnanosecondsscalardatetime_diffyearsscalardatetime_diffmonthsscalardatetime_diffdaysscalardatetime_diffhoursscalardatetime_diffminutesscalardatetime_diffsecondsscalardatetime_diffmillisecondsscalardatetime_diffmicrosecondsscalardatetime_diffnanosecondsscalardatetime_truncyearscalardatetime_truncmonthscalardatetime_truncdayscalardatetime_trunchourscalardatetime_truncminutescalardatetime_truncsecondscalardatetime_truncmillisecondscalardatetime_truncmicrosecondscalardatetime_truncnanosecondscalardatetime_partyearscalardatetime_partmonthscalardatetime_partdayscalardatetime_parthourscalardatetime_partminutescalardatetime_partsecondscalardatetime_partmillisecondscalardatetime_partmicrosecondscalardatetime_partnanosecondscalardatetime_isowkyearscalardatetime_isowkmonthscalardatetime_isowkdayscalardatetime_isowkhourscalardatetime_isowkminutescalardatetime_isowksecondscalardatetime_isowkmillisecondscalardatetime_isowkmicrosecondscalardatetime_isowknanosecondscalardatetime_isoyryearscalardatetime_isoyrmonthscalardatetime_isoyrdayscalardatetime_isoyrhourscalardatetime_isoyrminutescalardatetime_isoyrsecondscalardatetime_isoyrmillisecondscalardatetime_isoyrmicrosecondscalardatetime_isoyrnanosecondscalardatetime_dayyearscalardatetime_daymonthscalardatetime_daydayscalardatetime_dayhourscalardatetime_dayminutescalardatetime_daysecondscalardatetime_daymillisecondscalardatetime_daymicrosecondscalardatetime_daynanosecondscalardatetime_houryearscalardatetime_hourmonthscalardatetime_hourdayscalardatetime_hourhourscalardatetime_hourminutescalardatetime_hoursecondscalardatetime_hourmillisecondscalardatetime_hourmicrosecondscalardatetime_hournanosecondscalardatetime_minuteyearscalardatetime_minutemonthscalardatetime_minutedayscalardatetime_minutehourscalardatetime_minuteminutescalardatetime_minutesecondscalardatetime_minutemillisecondscalardatetime_minutemicrosecondscalardatetime_minutenanosecondscalardatetime_secondyearscalardatetime_secondmonthscalardatetime_seconddayscalardatetime_secondhourscalardatetime_secondminutescalardatetime_secondsecondscalardatetime_secondmillisecondscalardatetime_secondmicrosecondscalardatetime_secondnanosecondscalardatetime_millisecondyearscalardatetime_millisecondmonthscalardatetime_milliseconddayscalardatetime_millisecondhourscalardatetime_millisecondminutescalardatetime_millisecondsecondscalardatetime_millisecondmillisecondscalardatetime_millisecondmicrosecondscalardatetime_millisecondnanosecondscalardatetime_microsecondyearscalardatetime_microsecondmonthscalardatetime_microseconddayscalardatetime_microsecondhourscalardatetime_microsecondminutescalardatetime_microsecondsecondscalardatetime_microsecondmillisecondscalardatetime_microsecondmicrosecondscalardatetime_microsecondnanosecondscalardatetime_nanosecondyearscalardatetime_nanosecondmonthscalardatetime_nanoseconddayscalardatetime_nanosecondhourscalardatetime_nanosecondminutescalardatetime_nanosecondsecondscalardatetime_nanosecondmillisecondscalardatetime_nanosecondmicrosecondscalardatetime_nanosecondnanosecondscalardatetime_todatetimeyearscalardatetime_todatetimemonthscalardatetime_todatedayscalardatetime_todatetimehourscalardatetime_todatetimeminutescalardatetime_todatetimesecondscalardatetime_todatetimemillisecondscalardatetime_todatetimemicrosecondscalardatetime_todatetimenanosecondscalardatetime_totimeofdayhourscalardatetime_totimeofdayminutescalardatetime_totimeofdaysecondscalardatetime_totimeofdaymillisecondscalardatetime_totimeofdaymicrosecondscalardatetime_totimeofdayscalardatetime_todatetimezonescalardatetime_todurationscalardatetime_toscalarscalardatetime_fromscalarscalardatetime_parsescalardatetime_formatscalardatetime_nowscalardatetime_utcnowscalardatetime_addyearsscalardatetime_addmonthsscalardatetime_adddaysscalardatetime_addhoursscalardatetime_addminutesscalardatetime_addsecondsscalardatetime_addmillisecondsscalardatetime_addmicrosecondsscalardatetime_addnanosecondsscalardatetime_subtractyearsscalardatetime_subtractmonthsscalardatetime_subtractdaysscalardatetime_subtracthoursscalardatetime_subtractminutesscalardatetime_subtractsecondsscalardatetime_subtractmillisecondsscalardatetime_subtractmicrosecondsscalardatetime_subtractnanosecondsscalardatetime_diffyearsscalardatetime_diffmonthsscalardatetime_diffdaysscalardatetime_diffhoursscalardatetime_diffminutesscalardatetime_diffsecondsscalardatetime_diffmillisecondsscalardatetime_diffmicrosecondsscalardatetime_diffnanosecondsscalardatetime_truncyearscalardatetime_truncmonthscalardatetime_truncdayscalardatetime_trunchourscalardatetime_truncminutescalardatetime_truncsecondscalardatetime_truncmillisecondscalardatetime_truncmicrosecondscalardatetime_truncnanosecondscalardatetime_partyearscalardatetime_partmonthscalardatetime_partdayscalardatetime_parthourscalardatetime_partminutescalardatetime_partsecondscalardatetime_partmillisecondscalardatetime_partmicrosecondscalardatetime_partnanosecondscalardatetime_isowkyearscalardatetime_isowkmonthscalardatetime_isowkdayscalardatetime_isowkhourscalardatetime_isowkminutescalardatetime_isowksecondscalardatetime_isowkmillisecondscalardatetime_isowkmicrosecondscalardatetime_isowknanosecondscalardatetime_isoyryearscalardatetime_isoyrmonthscalardatetime_isoyrdayscalardatetime_isoyrhourscalardatetime_isoyrminutescalardatetime_isoyrsecondscalardatetime_isoyrmillisecondscalardatetime_isoyrmicrosecondscalardatetime_isoyrnanosecondscalardatetime_dayyearscalardatetime_daymonthscalardatetime_daydayscalardatetime_dayhourscalardatetime_dayminutescalardatetime_daysecondscalardatetime_daymillisecondscalardatetime_daymicrosecondscalardatetime_daynanosecondscalardatetime_houryearscalardatetime_hourmonthscalardatetime_hourdayscalardatetime_hourhourscalardatetime_hourminutescalardatetime_hoursecondscalardatetime_hourmillisecondscalardatetime_hourmicrosecondscalardatetime_hournanosecondscalardatetime_minuteyearscalardatetime_minutemonthscalardatetime_minutedayscalardatetime_minutehourscalardatetime_minuteminutescalardatetime_minutesecondscalardatetime_minutemillisecondscalardatetime_minutemicrosecondscalardatetime_minutenanosecondscalardatetime_secondyearscalardatetime_secondmonthscalardatetime_seconddayscalardatetime_secondhourscalardatetime_secondminutescalardatetime_secondsecondscalardatetime_secondmillisecondscalardatetime_secondmicrosecondscalardatetime_secondnanosecondscalardatetime_millisecondyearscalardatetime_millisecondmonthscalardatetime_milliseconddayscalardatetime_millisecondhourscalardatetime_millisecondminutescalardatetime_millisecondsecondscalardatetime_millisecondmillisecondscalardatetime_millisecondmicrosecondscalardatetime_millisecondnanosecondscalardatetime_microsecondyearscalardatetime_microsecondmonthscalardatetime_microseconddayscalardatetime_microsecondhourscalardatetime_microsecondminutescalardatetime_microsecondsecondscalardatetime_microsecondmillisecondscalardatetime_microsecondmicrosecondscalardatetime_microsecondnanosecondscalardatetime_nanosecondyearscalardatetime_nanosecondmonthscalardatetime_nanoseconddayscalardatetime_nanosecondhourscalardatetime_nanosecondminutescalardatetime_nanosecondsecondscalardatetime_nanosecondmillisecondscalardatetime_nanosecondmicrosecondscalardatetime_nanosecondnanosecondscalardatetime_todatetimeyearscalardatetime_todatetimemonthscalardatetime_todatedayscalardatetime_todatetimehourscalardatetime_todatetimeminutescalardatetime_todatetimesecondscalardatetime_todatetimemillisecondscalardatetime_todatetimemicrosecondscalardatetime_todatetimenanosecondscalardatetime_totimeofdayhourscalardatetime_totimeofdayminutescalardatetime_totimeofdaysecondscalardatetime_totimeofdaymillisecondscalardatetime_totimeofdaymicrosecondscalardatetime_totimeofdayscalardatetime_todatetimezonescalardatetime_todurationscalardatetime_toscalarscalardatetime_fromscalarscalardatetime_parsescalardatetime_formatscalardatetime_nowscalardatetime_utcnowscalardatetime_addyearsscalardatetime_addmonthsscalardatetime_adddaysscalardatetime_addhoursscalardatetime_addminutesscalardatetime_addsecondsscalardatetime_addmillisecondsscalardatetime_addmicrosecondsscalardatetime_addnanosecondsscalardatetime_subtractyearsscalardatetime