Windows 10 & Windows Server Notes

Sharing Permissions

In 'Sharing | Share...' dialog, it somehow may not show all permissions. Click 'Sharing | Advanced Sharing... | Permissions', if 'Everyone' is there, it might be a good idea to remove it.

Check users logged on

query user

Excel error open file

this refers to the following error:

Microsoft Office Excel cannot access the file 'd:\testing\testing.xls'.
There are several possible reasons:
• The file name or path does not exist
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.

This can be fixed very easily: Just create the following dir:

REM for Windows x64:

md C:\Windows\SysWOW64\config\systemprofile\Desktop

REM for Windows x86:

md C:\Windows\System32\config\systemprofile\Desktop

Find 'Startup'

• in start menu, right click on an icon, and select 'More | Open file location'
• and File Explorer points to 'C:\~ProgramData\Microsoft\Windows\Start Menu\Programs'.
• inside the above folder, there is 'Startup'.

Batch file

Rename files with a pattern:

REM example file name: HIS_DATA_FILE_20190101.CSV
ren HIS_DATA_FILE_*.CSV HER_DATA_FILE_????????.CSV
REM or:
ren HIS_DATA_FILE_*.CSV HER_??????????????????.CSV

Note: each '?' represent a char in original file name at the same position.

Cygwin

Compare XML files

xmllint --format one.xml > 1.xml  
xmllint --format two.xml > 2.xml  
diff 1.xml 2.xml  

Accessing network shared dir

just cd to that dir, replace '\' with '/' in path.