Archive

Archive for November, 2010

Where is my Hibernate Button (Windows 7)

29/11/2010 3 comments

Hello All,

My CEO Ask me how to show the Hibernate button on the start menu, I didn’t used it on my Win 7  (I like to shut down my computer) so i found this command:

Powercfg.exe /hibernate on

(from Start -> Run Command) –  work like magic, faster than search it in the control panel

If you want to disable this option, use off switch instead the on

That’s it, enjoy

Categories: Windows Tags:

Resources Installed Date Report On SCCM 2007

Hey All, This is My First post on this blog, My colleagues From Diplomat will Join us Soon.

And now for the issue presented, Say you want to list all your all OS’s by installed date, sccm offer you this for every version and not for all your operating systmes, So if you want your  report to look like this one:

All You need to do is creat new report and add This SQL statement:

SELECT     DISTINCT dbo.v_R_System.ResourceID, dbo.v_R_System.Name0, dbo.v_GS_OPERATING_SYSTEM.InstallDate0,
dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, dbo.v_GS_OPERATING_SYSTEM.Caption0, dbo.v_GS_OPERATING_SYSTEM.Version0,
dbo.v_GS_OPERATING_SYSTEM.CSDVersion0
FROM         dbo.v_R_System INNER JOIN
dbo.v_RA_System_IPAddresses ON dbo.v_R_System.ResourceID = dbo.v_RA_System_IPAddresses.ResourceID INNER JOIN
dbo.v_GS_OPERATING_SYSTEM ON dbo.v_R_System.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID
WHERE     (dbo.v_R_System.Client0 = 1)

Thats It, Have Fun

Yair

Categories: Microsoft, SCCM Tags: ,