How to handle a comma in a filename with WMIC?

[npocmaka_]

Thanks for the pointers, npocmaka.

But this thread on a Russian forum proved to be instructive. Retouching the script I found there, I ended up with:

Code: Select all

set ^"js=javascript:close(new ActiveXObject('Scripting.^
FileSystemObject'^).GetStandardStream(1^).Write(new String(new ^
Enumerator(new ActiveXObject('WbemScripting.SWbemLocator'^).^
ConnectServer('.','root\\cimv2'^).ExecQuery('Select LocalDateTime ^
from Win32_OperatingSystem where Primary=True'^)^).item(^).^
LocalDateTime^)^)^);^"

for /f %%t in ('mshta "%js%"') do echo(WMI LocalDateTime: %%t

Long-winded, but it works! And it should work for everyone, even any poor Windows XP Home bunnies still left out there.

- SB

Yes.There's no big difference when you use WMI classes through the activex objects?But after I saw this code started to wonder if it is necessary to create WMI objects to the time? Both javascript and vbscript have a good set date/time functions. According to me these classes are most interesting for enhancements of batch capabilities

[foxidrive]

Code: Select all

set ^"js=javascript:close(new ActiveXObject('Scripting.^
FileSystemObject'^).GetStandardStream(1^).Write(new String(new ^
Enumerator(new ActiveXObject('WbemScripting.SWbemLocator'^).^
ConnectServer('.','root\\cimv2'^).ExecQuery('Select LocalDateTime ^
from Win32_OperatingSystem where Primary=True'^)^).item(^).^
LocalDateTime^)^)^);^"

for /f %%t in ('mshta "%js%"') do echo(WMI LocalDateTime: %%t

Long-winded, but it works! And it should work for everyone, even any poor Windows XP Home bunnies still left out there.

It even returns the date time string in Windows 2000 Pro.

[Sponge Belly]

Yes.There's no big difference when you use WMI classes through the activex objects?But after I saw this code started to wonder if it is necessary to create WMI objects to the time? Both javascript and vbscript have a good set date/time functions.

True, but look at the output from this little snippet:

Code: Select all

for /f "delims=" %%d in ('mshta ^"javascript:close(^
new ActiveXObject('Scripting.FileSystemObject'^).^
GetStandardStream(1^).Write(new Date(^)^)^);^"') ^
do echo(%%d

Mon Feb 3 12:58:56 UTC 2014

Mon? Feb? Not exactly locale-independent. You can use GetYear(), GetMonth() and friends to access unambiguous numeric parts of the date, but why bother when there’s WMI’s numeric timestamp?

Code: Select all

set ldt=For Each objItem in GetObject(""winMgmts:\\.\root\cimv2""^).^
ExecQuery(""Select LocalDateTime from Win32_OperatingSystem ^
where Primary=True""^):CreateObject(""Scripting.FileSystemObject""^).^
GetStandardStream(1^).Write objItem.LocalDateTime:Next:Close

for /f %%l in ('mshta vbscript:execute("%ldt%"^)') ^
do echo(%%l

20140203152208.013000+000

It’s trivial to chop up this string into year, month, day and time. And you can even calculate the weekday using the functions posted by Aacini in How Do I State that a Variable Is a Date? Best of all, the above code should work across all versions of Windows from 2000 Pro (according to Foxi) onwards regardless of locale.

- SB

PS: See also updated LastModified code snippet from several posts back.