Archive

Archive for the ‘Report’ Category

Find files easily with simple batch file

04 August 2018 Leave a comment

Knowing the files on computers is one of the issues that every system administrator usually deals with. You can easily learn it by creating a simple batch command with the following commands.

open Notepad and copy following commands and paste in this note file.

echo %SystemRoot%\Security\logs\scecomp.dat > c:\%computername%.txt
dir %SystemRoot%\Security\logs\scecomp.dat >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\System32\iapfltr.dat >> c:\%computername%.txt
dir %SystemRoot%\System32\iapfltr.dat >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\Security\logs\sceRoot.dat >> c:\%computername%.txt
dir %SystemRoot%\Security\logs\sceRoot.dat >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\Security\logs\sceback.old >> c:\%computername%.txt
dir %SystemRoot%\Security\logs\sceback.old >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\Security\logs\scesetup.dat >> c:\%computername%.txt
dir %SystemRoot%\Security\logs\scesetup.dat >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\System32\ntsec.dat >> c:\%computername%.txt
dir %SystemRoot%\System32\ntsec.dat >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\System32\cacls.exe >> c:\%computername%.txt
dir %SystemRoot%\System32\cacls.exe >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\System32\Drivers\cacls.exe >> c:\%computername%.txt
dir %SystemRoot%\System32\Drivers\cacls.exe >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\System32\drivers\adpu160.sys >> c:\%computername%.txt
dir %SystemRoot%\System32\drivers\adpu160.sys >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\System32\adpu160.sys >> c:\%computername%.txt
dir %SystemRoot%\System32\adpu160.sys >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\System32\Drivers\adpu160.sys >> c:\%computername%.txt
dir %SystemRoot%\System32\Drivers\adpu160.sys >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\IME\IMESC5\DICTS\PINTLGBS.IMD >> c:\%computername%.txt
dir %SystemRoot%\IME\IMESC5\DICTS\PINTLGBS.IMD >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\Security\logs\sceback.old >> c:\%computername%.txt
dir %SystemRoot%\Security\logs\sceback.old >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\system32\desk.cfg >> c:\%computername%.txt
dir %SystemRoot%\system32\desk.cfg >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\IME\IMESC5\DICTS\PINTLGBP.IMD >> c:\%computername%.txt
dir %SystemRoot%\IME\IMESC5\DICTS\PINTLGBP.IMD >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\system32\svcsstat.exe >> c:\%computername%.txt
dir %SystemRoot%\system32\svcsstat.exe >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\system32\winhttpc.dll >> c:\%computername%.txt
dir %SystemRoot%\system32\winhttpc.dll >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo svcsstat.dll /s >> c:\%computername%.txt
dir svcsstat.dll /s >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\system32\wshnetc.dll >> c:\%computername%.txt
dir %SystemRoot%\system32\wshnetc.dll >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt
echo %SystemRoot%\SysWow64\wshnetc.dll >> c:\%computername%.txt
dir %SystemRoot%\SysWow64\wshnetc.dll >> c:\%computername%.txt
echo —————————————————— >> c:\%computername%.txt

save_as_batch_file

Save as findfiles.cmd to Desktop

run_as_administrator

open cmd as Administrator

deskto_cmd

navige to Desktop and run the batch file

system_root

The file created with the machine name will appear in the root directory.

batch_file_output

Enjoy!

Advertisements

Access useful information from the SCCM’s DB #1

There were thousands of machines in the majority of the large companies I consulted and they wanted to follow these machines with SCCM. Reports that are available in the SCCM sometimes may not provide enough information. In such cases the solution comes with Microsoft SQL Management Studio. If you are a system administrator, you will find yourself writing SQL 🙂

Microsoft SQL Server Management Studio 17

I’m not sure if I can help you write SQL, but I have a lot of ready-made SQL that my customers like a lot. I plan to share these with you one by one. Most of my customers wanted a report like the one below. I have changed the report according to the wishes of the years and I share the final status with you.

Read more…

SCCM Reporting Server error (Solution)

SCCM 2012 R2 SP1 Default reports gives the following error when trying to run.

system.web.services.protocols.soapexception an error has occurred during report processing

Investigation Steps:

Open the srsrp.log file with cmtrace and open any raport in SCCM.

You can see the error logs in the file.

Read more…