Create Report in SCCM with Computer Information

This how-to shows how to create a report in System Center Configuration Manager with computer information like serial number etc.

Open the Management Console. Navigate to Reporting. Right click on Reports and select New –> Report.  image
Give it a name.

Select the category under which the report will be displayed. (eg Hardware – General)

Click on: Edit SQL Statement.

image
Paste the Statement(displayed and the bottom of this blog post.) in the SQL Statement box.

Remove the default statement.

image
Run the report and it will display al kind off useful stuff. Like the Serial Number. Knipogende emoticon image

Continue reading “Create Report in SCCM with Computer Information”

Keyboard Shortcuts

I’m positive that working with the keyboard is way faster then working in combination with the mouse. But you must know the shortcuts-keystrokes-etc etc Knipogende emoticon So here is the list I’m using. The list is updated on a regular basis.

Copy, Paste, Cut, Delete

CTRL+C = Copy
CTRL+V = Paste
CTRL+X = Cut
CTRL+Z = Undo
CTRL+Insert = Copy (This one I use very often, learned it in the old days Knipogende emoticon)
Shift+Insert = Paste
Shift+Delete = Permanently Delete

The Windows Key

Windows+R = Run
Windows+P = Projector/monitor/Dual/Etc (Keep Windows key pressed)
Windows+E = Explorer
Windows+D = Show Desktop (Press it again brings back the applications)
Windows+F = Find
Windows+L = Lock Windows
Windows+M = Minimize all the applications
Windows+Pause = Computer Management

Application Switching

ALT+TAB = Good old application switching
Shift+ALT+TAB = Reverse application switching
Windows+TAB = New Aero application switching
Windows+# (Like Windows+1) = The number equals the position of the application or icons in the taskbar.
Windows+T = Switching applications and icons on the taskbar with peak

Windows Explorer (Shortcuts within Windows Explorer)

ALT+Space = Right click on top left (Move, Size, Minimize, Maximize, Close)
TAB = Switching area’s
Shift+F10 = Context menu of selected icon
Space = Select icon
ALT = Activate top menu

Windows

CTRL+Shift+Escape = Task Manager
CTRL+Escape = Start Menu
CTRL+ALT+Delete = Duhhhh Emoticon die tong uitsteekt

Internet Explorer

CTRL+TAB = Tab’s switching

Outlook

CTRL+Enter = Send composed email

 

Q: So, how to show the desktop and right click on the recycled bin?
A: Windows+D, Navigate with arrows to recycled bin, SHIFT+F10.

Q: Why are you using SHIFT+F10, CTRL+Escape etc?
A: Long long time ago, there weren’t keyboards with the Windows keys. Knipogende emoticon

Slow NIC speed on battery power

When running on battery power, my laptop has slow network speed. When connecting the adapter the network speed is normal Knipogende emoticon

Open the registry, expand to: HKLM\SYSTEM\CurrentControlSet\Control\Class

Search for: AutoPowerSaveModeEnabled

Change the value to: 0

image

Before: 99% (10Mbps)

image

After: 10% (1Gbps)

image

Prevent SCCM from installing files on a specific drive

By default, the Configuration Manager 2007 site server role component installation files are installed on the first available NTFS formatted disk drive with the most available free disk space. However, some files are not installed in the default installation folder. For example, files are installed in the following folders:

  • The SMS_CCM folder (if the management point site system role is enabled on the computer);
  • The Inetpub\wwwroot\SMSComponent and Inetpub\wwwroot\SMSReporting_sitecode folders (if the reporting point role is enabled on the computer);
  • The %Windir%\System32 folder.

Configuration Manager 2007 will not install site role component files on a drive that contains a file named no_sms_on_drive.sms. Instead, site role components will be installed on a different NTFS formatted disk drive that does not contain the no_sms_on_drive.sms file.

The no_sms_on_drive.sms file prevents site system role component installation, on a drive with this file present, for all site systems that are installed by site component manager. If site role installation files are already present on the drive before placing the no_sms_on_drive.sms file on the drive, the installation files are not moved.

  1. Create an empty file named no_sms_on_drive.sms.

  2. Place the no_sms_on_drive.sms file at the root folder of any drive that you want to prevent Configuration Manager 2007 from installing files on.

  3. image