Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Add a rowset for new disk information collection from SQL logscout #356

Closed
PiJoCoder opened this issue Jun 12, 2024 · 1 comment
Closed

Add a rowset for new disk information collection from SQL logscout #356

PiJoCoder opened this issue Jun 12, 2024 · 1 comment
Assignees
@PiJoCoder
Labels
enhancement sqllogscout consider if related to SQLLogScout wave 4

Comments

@PiJoCoder
Copy link
Contributor

Need rowset for this type of output

-- Disk_Information --
Disk_Drive           Disk_Model                          Partn_Id Volume_Size_GB Volume_Free_Space_GB Volume_Caption         Volume_Label       Primary_Part Boot_Part  Volume_Letter Total_Disk_Size_GB BytesPerSector SCSIPort
-------------------- ----------------------------------- -------- -------------- -------------------- ---------------------- ------------------ ------------ ---------- ------------- ------------------ -------------- --------
\\.\PHYSICALDRIVE1   SAMPLED  SCSI Disk Device           0        1              0                    Disk #1, Partition #0                     False        False                    698.64             512            1       
\\.\PHYSICALDRIVE1   SAMPLED  SCSI Disk Device           1        0.1            0                    Disk #1, Partition #1                     True         True                     698.64             512            1       
\\.\PHYSICALDRIVE1   SAMPLED  SCSI Disk Device           2        689.08         688.68               Disk #1, Partition #2  T010000000B        True         False      D:            698.64             512            1       
\\.\PHYSICALDRIVE1   SAMPLED  SCSI Disk Device           3        8.33           0                    Disk #1, Partition #3                     False        False                    698.64             512            1       
\\.\PHYSICALDRIVE0   WDC PC X3000 SDABCDE-1000-1000      0        0.25           0                    Disk #0, Partition #0                     True         True                     953.86             512            0       
\\.\PHYSICALDRIVE0   WDC PC X3000 SDABCDE-1000-1000      1        952.62         117.68               Disk #0, Partition #1  Windows            True         False      C:            953.86             512            0       
\\.\PHYSICALDRIVE0   WDC PC X3000 SDABCDE-1000-1000      2        0.98           0                    Disk #0, Partition #2                     False        False                    953.86             512            0
@PiJoCoder PiJoCoder added enhancement sqllogscout consider if related to SQLLogScout wave 4 labels Jun 12, 2024
@PiJoCoder PiJoCoder self-assigned this Jun 12, 2024
@PiJoCoder
Copy link
Contributor Author

After an import from a collection, a table looks like this:

image

PiJoCoder added a commit that referenced this issue Jun 13, 2024
@PiJoCoder
#356 disk information rowset
9a42645
PiJoCoder added a commit that referenced this issue Jul 6, 2024
@PiJoCoder
#356 disk information rowset (#357)
ed14caa
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@PiJoCoder PiJoCoder

Labels
enhancement sqllogscout consider if related to SQLLogScout wave 4
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@PiJoCoder