Microsoft Security issues - File lists

%3CLINGO-SUB%20id%3D%22lingo-sub-2615822%22%20slang%3D%22en-US%22%3EMicrosoft%20Security%20issues%20-%20File%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2615822%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EHas%20others%20fighting%20with%20the%20Microsoft's%20CSV%20files%20when%20trying%20to%20check%20the%20files%20related%20to%20updates.%20Let%20us%20the%20latest%20printing%20nightmare%20issue%20as%20an%20example%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Ftopic%2Fjuly-6-2021-kb5004946-os-build-18363-1646-out-of-band-18c5ffac-6015-4b3a-ba53-a73c3d3ed505%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EJuly%206%2C%202021%E2%80%94KB5004946...%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20bottom%20you%20have%20the%20%22File%20Information%22%2C%20and%20there%20is%20a%20link%20to%20the%20CSV%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you%20download%20the%20file%2C%20you%20are%20getting%20a%20file%20which%20contains%20line%20like%20followings%3A%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%230000FF%22%3EWindows%2010%20version%201909%20x86-based%20Out-of-band%2C%2C%2C%2C%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%20color%3D%22%230000FF%22%3EFile%20name%2CFile%20version%2CDate%2CTime%2CFile%20size%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%20color%3D%22%230000FF%22%3EMicrosoft.HyperV.PowerShell.Cmdlets.resources.dll%2C10.0.18362.959%2C7-Jul-2020%2C7%3A05%2C%2276%2C800%22%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%230000FF%22%3E.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%230000FF%22%3E.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%230000FF%22%3EWindows%2010%20version%201909%20x64-based%20Out-of-band%2C%2C%2C%2C%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%20color%3D%22%230000FF%22%3EFile%20name%2CFile%20version%2CDate%2CTime%2CFile%20size%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%20color%3D%22%230000FF%22%3Eaagwrapper.dll%2C10.0.18362.1049%2C17-Aug-2020%2C0%3A44%2C%2267%2C072%22%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%230000FF%22%3E.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%230000FF%22%3E.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20they%20basically%20have%20multiple%20CSV%20files%20in%20one%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20cool%20it%20would%20be%2C%20if%20they%20are%20publishing%20these%20files%20so%20that%20OS%20version%20is%20one%20of%20the%20column%20instead%20of%20own%20line%3F%20And%20then%20they%20do%20have%20one%20big%20CSV%20file.%20Something%20like%20following%3A%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%230000FF%22%3EWindows%20OS%2C%20File%20name%2CFile%20version%2CDate%2CTime%2CFile%20size%3C%2FFONT%3E%3C%2FP%3E%3CP%3EThen%20it%20would%20be%20possible%20to%20use%20PS%20against%20that%20file%20directly.%20You%20only%20need%20to%20do%20filtering%20based%20your%20OS%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%23DoLessDoSmarter%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2615822%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESecurity%20updates%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Super Contributor

Hi,

Has others fighting with the Microsoft's CSV files when trying to check the files related to updates. Let us the latest printing nightmare issue as an example: July 6, 2021—KB5004946... 

On bottom you have the "File Information", and there is a link to the CSV file.

 

When you download the file, you are getting a file which contains line like followings:

Windows 10 version 1909 x86-based Out-of-band,,,,
File name,File version,Date,Time,File size
Microsoft.HyperV.PowerShell.Cmdlets.resources.dll,10.0.18362.959,7-Jul-2020,7:05,"76,800"

.

.

Windows 10 version 1909 x64-based Out-of-band,,,,
File name,File version,Date,Time,File size
aagwrapper.dll,10.0.18362.1049,17-Aug-2020,0:44,"67,072"

.

.

 

So they basically have multiple CSV files in one file.

 

How cool it would be, if they are publishing these files so that OS version is one of the column instead of own line? And then they do have one big CSV file. Something like following:

Windows OS, File name,File version,Date,Time,File size

Then it would be possible to use PS against that file directly. You only need to do filtering based your OS version.

 

#DoLessDoSmarter

 

 

0 Replies
www.000webhost.com