Archive for the ‘Default’ Category.

SQL Query to list products from SCCM Database

To list products that are installed on a Server using SQL Query to SSCM database you can use the Table v_GS_SoftwareProduct. This table contains “Lists the products found on each Configuration Manager client.”

select *
FROM v_r_system as vrs
join v_GS_INSTALLED_SOFTWARE as VIS on VIS.resourceid = vrs.resourceid
where
Name0 LIKE ‘%Server Name%’

A full list of the Tables is : https://technet.microsoft.com/en-us/library/dd334659.aspx

 

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

SCOM Query Disk Space for 1 Day

select
vManagedEntity.Path
,Perf.vPerfdaily.DateTime
,Perf.vPerfdaily.SampleCount
,vPerformanceRule.ObjectName
,vPerformanceRule.CounterName
,vManagedEntity.Name
,Perf.vPerfdaily.Averagevalue
,Perf.vPerfdaily.MinValue
,Perf.vPerfdaily.MaxValue
,vRule.RuleDefaultName

from Perf.vPerfDaily
join vPerformanceRuleInstance on vPerformanceRuleInstance.PerformanceRuleInstanceRowid=Perf.vPerfDaily.PerformanceRuleInstanceRowid

join vPerformanceRule on vPerformanceRule.RuleRowId=vPerformanceRuleInstance.RuleRowId
join vManagedEntity on vManagedEntity.ManagedEntityRowid=Perf.vPerfDaily.ManagedEntityRowId
join vRule on vRule.RuleRowId=vPerformanceRuleInstance.RuleRowId
where Perf.vPerfDaily.Datetime between ‘2015-02-01’ and ‘2015-02-02′
and vPerformanceRule.ObjectName=’LogicalDisk’
and vPerformanceRule.CounterName=’Free Megabytes’
and vRule.RuleDefaultName LIKE ‘%Logical Disk Free Megabytes%’

Order by Path,Name

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

How to enable Log for an Microsoft Windows Log

In case tat you need to Enable the Log for an Microsoft Windows Log for example the Operational Log for Print Service you can do it from the MMC.

Enable Log

Other 2 options are:

– Command line:  wevtutil sl Microsoft-Windows-PrintService/Operational /e:true /q

– Change registry Key:  [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WINEVT\Channels\Microsoft-Windows-PrintService/Operational]
“Enabled”=dword:00000001

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

I got my MCT Certification!

Dec 23 2011 Congratulations! On behalf of Microsoft, we are happy to welcome you to the Microsoft Certified Trainer (MCT) Program. You will be sent a Microsoft Certified Trainer Welcome Kit within four to six weeks.

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

Microsoft Security Bulletin Summary June 2011

Numai ce incepeam sa ne obisnuim si noi cu putine update-uri lunare de la Microsoft si iata… astazi tocmai am instalat 120MB de update-uri :). Luna aceasta au fost lansate pe langa obisnuitele updaturi de sistem de operare, update-urile pentru Office, .NET Framework 4,  .NET Framework 3.5.1, si  Internet Explorer 9.
Pentru mai multe infrmatii puteti urmarii webcastul de aceasta luna TechNet Webcast: Information about Microsoft Security  Bulletins for July (Level 200)

Lista de updaturi de pe PC-ul meu de luna aceasta:
Cumulative Security Update for Internet Explorer 9 for Windows 7 for x64-based Systems (KB2530548)
Definition Update for Microsoft Security Essentials – KB2310138 (Definition 1.105.1933.0)
Security Update for .NET Framework 3.5.1 on Windows 7 and Windows Server 2008 R2 SP1 for x64-based Systems (KB2478662)
Security Update for .NET Framework 3.5.1 on Windows 7 and Windows Server 2008 R2 SP1 for x64-based Systems (KB2518869)
Security Update for Microsoft .NET Framework 4 on Windows XP, Windows Server 2003, Windows Vista, Windows 7, Windows Server 2008, Windows Server 2008 R2 for x64-based Systems (KB2478663)
Security Update for Microsoft .NET Framework 4 on Windows XP, Windows Server 2003, Windows Vista, Windows 7, Windows Server 2008, Windows Server 2008 R2 for x64-based Systems (KB2518870)
Security Update for Microsoft Excel 2010 (KB2523021), 64-Bit Edition
Security Update for Microsoft InfoPath 2010 (KB2510065), 64-Bit Edition
Security Update for Microsoft Silverlight (KB2512827)
Security Update for Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package (KB2538242)
Security Update for Microsoft Visual C++ 2008 Service Pack 1 Redistributable Package (KB2538243)
Security Update for Windows 7 for x64-based Systems (KB2476490)
Security Update for Windows 7 for x64-based Systems (KB2503665)
Security Update for Windows 7 for x64-based Systems (KB2525694)
Security Update for Windows 7 for x64-based Systems (KB2536275)
Security Update for Windows 7 for x64-based Systems (KB2536276)
Security Update for Windows 7 for x64-based Systems (KB2544893)
Update for Microsoft Office 2010 (KB2523113), 64-Bit Edition
Windows Malicious Software Removal Tool x64 – June 2011 (KB890830)

In fiecare luna puteti sa vizitati pagina Microsoft Security Bulletin Summaries and Webcasts pentru a fi la zi cu problemele de securitate care au fost descoperite in luna resepectiva.

VN:F [1.9.20_1166]
Rating: 9.0/10 (1 vote cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

Spatiul liber – Partitia System

Sunt foarte multe posturi pe interenet despre probleme legate de spatiul pe partitial sistemului de operare. Unele persoane afirma ca stocarea informatiei pe HDD nu mai costa asa de mult si atunci unde este problema? Un calcul simplu arata ca in cazul HarDisk-urilor interne 10GB spatiu de stocare costa 3RON. Un contraargument pentru acest lucru este umatorul: in cazul SolidStateDrive (SSD) 10GB spatiu de stocare costa 75RON, iar costurile pentru capacitati mari este urias. Ce fac in acest caz?

Exact acest lucru incerc sa il explic pentru Windows 7, incepand cu unele sfaturi:
-Nu instala aplicatii care nu iti sunt necesare si mai ales pe partitia Sistemului.
-Nu tine fisiere mari pe Desktop
-Goleste Recycle Bin
-Foloseste cu incredere Disk Cleanup dar si optiunea avansata Clean up system files (in cazul in care ai instalat SP1 poti selecta pentru clean inclusiv Service Backup Files)
– Schimba Curent location a fisierelor temporare de la Internet Explorer. Aceasta optiune se gaseste in Interenet Options > General Tab la categoria Browsing history > Setings > Move Folder
-Activeaza Show hiden files, folders and drives ( Folder Options > View tab ) pentru a vizualiza fisierele ascunse de pe partitii ( ! Nu stergeti fisierele care nu stiti ce fac deoarece pot afecta sistemul de operare )
-Verifica dimensiunea folderului C:\Windows\Temp\ si sterge fiserele si folderele din acest path. Unele aplicatii uita sa faca curatenie.
Verifica cat de mare este profilul utilizatorilor care folosesc acel calculator, si vezi ce foldere/fisiere ocupa spatiul.
-In cazul in care ai instalat SP1 si vrei ca modificarile sa se comita sistemului de opeare (nu va mai fi posibila dezinstalarea) se paote folosi comanda dism /online /cleanup-image /spsuperseded , in cazul meu s-a eliberat 3GB din folderul C:\Windows\winsxs care contine versiuni anterioare ale anumitor fisiere
-In cazul in care iti mai trebuie spatiu poti dezactiva System Protection (nu recomand deoarece nu se stie cand iti e folositoare…) System Properties >tab-ul  System Protection > selectati partitia System si apasati Configure Turn off system protection
-Schimbati locatia unde se creaza paging file (Virtual memory) System Properties > Advanced > Settings de la categoria Performance > tab-ul Advanced > Change, debifati automaticaly manage paging file size for all drives. Setati pentru o alta partitie optiunea System managed size iar pentru partitia System setati o marime Custom de 1024MB (exista cateva motive foarte intemeiate legate de debuging OS pentru care nu trebuie sa selectati optiunea No paging file pentru partitia System )

In speranta ca acest articol va ajuta astept feedback si de ce nu completari!

VN:F [1.9.20_1166]
Rating: 1.0/10 (1 vote cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

Windows Virtual PC transfer fisiere

In cazul in care aveti probleme legate de viteza de transfer dintre Windows 7 si Windows Virtual PC exista o cheie de registrii care rezolva acest lucru.
Path: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
Dword Value: DisableTaskOffload
Value Data: 1
Un restart este necesar pentru ca aceasta modificare sa fie aplicata. Viteza de transfer aproximativa inainte de a modifica cheia in registrii era de aproximativ 5KB/s acum transferul de fisiere este instantaneu.
Atentie: nu dati Disable la Offload in cazul in care nu aveti probleme de transfer!
Mai multe detalii despre aceasta cheie de registrii putegi gasi pe site-ul Microsoft.

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

Cum se repara un Server!

Ai un server cu probleme si nu sti cum sa il repari! Aceasta este solutia 🙂

VN:F [1.9.20_1166]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

Produse si Solutii Microsoft

S-a intrebat cineva care sunt Produsele si Solutiile oferite de Microsft? Nimic mai simplu.

Produse

.NET Framework
Antigen
AppFabric
Application Virtualization
BizTalk Server
Commerce Server
Essential Business Server
Exchange Server
Expression
Forefront Family
Forefront Management
Forefront Protection & Access
Forefront Platform Technologies
Forms Server
Groove Server
Host Integration Server
Hyper-V Server
Live Services
Office Communications Server
Opalis
Project Server
Search Server
SharePoint Server
Small Business Server
SQL Azure
SQL Server
System Center Configuration Manager
System Center Data Protection Manager
System Center Essentials
System Center Family
System Center Mobile Device Manager
System Center Operations Manager
System Center Service Manager
System Center Virtual Machine Manager
Virtual Server
Visual Studio
Windows Azure
Windows Azure platform
Windows HPC Server
Windows Server Hyper-V
Windows Server
Windows Server Update Services
Windows Storage Server

Solutii

Active Directory
Application Lifecycle Management
Application Platform Optimization
Application Virtualization
Branch Infrastructure
Business Intelligence
Business Productivity Infrastructure
Business Ready Security
Core Infrastructure Optimization
Desktop Infrastructure
Desktop Virtualization
Enterprise Optimization
Enterprise Search
Failover Clustering
Internet Information Services (IIS)
Midsize Business Center

Microsoft Web Platform
Network Access Protection
Online Services
Optimized Datacenter
Partner Solutions
Remote Desktop Virtualization
Security
Server Virtualization
Service Oriented Architecture
Small Business Center
Solution Accelerators
Specialized Server
Virtualization
Virtualization Management
Virtualization Security
Windows Optimized Desktop

Aceasta este lista completa pe care Microsoft o ofera actualmente.

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.20_1166]
Rating: +1 (from 1 vote)

IE9 Beta

A aparut IE9 Beta. Arata.. diferit…
Vrei un Test Drive ?
Vrei demo cu IE9 si HTML5 ? Incearca cateva pagini.
Esti developer? Clik Aici.

E mai bun IE9? Voi ce parere aveti?
Eu unu nu am putut scrie acest post cu IE9 in modul Visual de la WordPress.

VN:F [1.9.20_1166]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)