Certificate Installation Commands

Root certificate installation Command.

Certutil.exe –addstore  root ‘’certificate name’’

Intermediate certificate installation command.

Certutil.exe –addstore CA ‘’Certificate name”

C:\>certutil.exe -?

402.203.0: 0x80070057 (WIN32: 87): ..CertCli Version

Verbs:

  -dump             -- Dump configuration information or files

  -decodehex        -- Decode hexadecimal-encoded file

  -decode           -- Decode Base64-encoded file

  -encode           -- Encode file to Base64

  -deny             -- Deny pending request

  -resubmit         -- Resubmit pending request

  -setattributes    -- Set attributes for pending request

  -setextension     -- Set extension for pending request

  -revoke           -- Revoke Certificate

  -isvalid          -- Display current certificate disposition

  -getconfig        -- Get default configuration string

  -ping             -- Ping Certificate Services Request interface

  -pingadmin        -- Ping Certificate Services Admin interface

  -CAInfo           -- Display CA Information

  -ca.cert          -- Retrieve the CA's certificate

  -ca.chain         -- Retrieve the CA's certificate chain

  -GetCRL           -- Get CRL

  -CRL              -- Publish new CRLs [or delta CRLs only]

  -shutdown         -- Shutdown Certificate Services

  -installCert      -- Install Certification Authority certificate

  -renewCert        -- Renew Certification Authority certificate

  -schema           -- Dump Certificate Schema

  -view             -- Dump Certificate View

  -deleterow        -- Delete server database row

  -backup           -- Backup Certificate Services

  -backupDB         -- Backup Certificate Services database

  -backupKey        -- Backup Certificate Services certificate and private key

  -restore          -- Restore Certificate Services

  -restoreDB        -- Restore Certificate Services database

  -restoreKey       -- Restore Certificate Services certificate and private ke

  -dynamicfilelist  -- Display Dynamic File List

  -databaselocations -- Display Database Locations

  -hashfile         -- Generate and display cryptographic hash over a file

  -store            -- Dump certificate store

  -addstore         -- Add certificate to store

  -delstore         -- Delete certificate from store

  -verifystore      -- Verify certificate in store

  -repairstore      -- Repair certificate KeyProvInfo in store

  -viewstore        -- Dump certificate store

  -viewdelstore     -- Delete certificate from store

  -dsPublish        -- Publish Certificate or CRL to DS

  -Template         -- Display Templates

  -TemplateCAs      -- Display CAs for Template

  -CATemplates      -- Display Templates for CA

  -URLCache         -- Display or delete URL cache entries

  -pulse            -- Pulse autoenrollment events

  -MachineInfo      -- Display DS machine object information

  -DCInfo           -- Display DC information

  -EntInfo          -- Display Enterprise information

  -TCAInfo          -- Display CA information

  -SCInfo           -- Display Smart Card information

  -verifykeys       -- Verify public/private key set

  -verify           -- Verify certificate, CRL or chain

  -sign             -- Re-sign CRL or Certificate

  -vroot            -- Create/Delete Web Virtual Roots and File Shares

  -oid              -- Display or set ObjectId display name

  -error            -- Display error code message text

  -getreg           -- Display registry value

  -setreg           -- Set registry value

  -delreg           -- Delete registry value

  -ImportKMS        -- Import user keys and certificates into server database

r key archival

  -ImportCert       -- Import a certificate file into the database

  -GetKey           -- Retrieve archived private key recovery blob

  -RecoverKey       -- Recover archived private key

  -MergePFX         -- Merge PFX files

  -ConvertEPF       -- Convert PFX files to EPF file

  -?                -- Display this usage message

CertUtil -?              -- Display a verb list (command list)

CertUtil -dump -?        -- Display help text for the "dump" verb

CertUtil -v -?           -- Display all help text for all verbs

CertUtil: -? command completed successfully.

Laptop with serial number Report

select v_R_System.Name0, v_GS_PC_BIOS.Manufacturer0, v_GS_PC_BIOS.SerialNumber0,v_GS_COMPUTER_SYSTEM.Model0
FROM v_R_System JOIN v_GS_PC_BIOS on  v_R_System.ResourceID =  v_GS_PC_BIOS.ResourceID JOIN v_GS_COMPUTER_SYSTEM on v_R_System.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID

SCCM NO Of Days of Advertisement status

SELECT DISTINCT v_Package.Name AS 'Package Name',(


v_ClientAdvertisementStatusSELECT COUNT(*) FROM v_ClientAdvertisementStatus WHERE .AdvertisementID=v_Advertisement.AdvertisementID) AS 'Total Targeted Machines',(


v_ClientAdvertisementStatus


Status machines'SELECT COUNT(*) FROM v_ClientAdvertisementStatus WHERE .AdvertisementID=v_Advertisement.AdvertisementIDAND v_ClientAdvertisementStatus.LastStateName IN('No Status')) AS 'No ,


v_ClientAdvertisementStatus(SELECT COUNT(*) FROM v_ClientAdvertisementStatus WHERE .AdvertisementID=v_Advertisement.AdvertisementID AND LastState!=0) AS 'Total Accepted Machines',


v_ClientAdvertisementStatus


PendINg'(SELECT COUNT(*) FROM v_ClientAdvertisementStatus WHERE .AdvertisementID=v_Advertisement.AdvertisementIDAND v_ClientAdvertisementStatus.LastStateName IN('Succeeded', 'Reboot )) AS 'Total Succeeded Machines',(


v_ClientAdvertisementStatusSELECT COUNT(*) FROM v_ClientAdvertisementStatus WHERE .AdvertisementID=v_Advertisement.AdvertisementIDAND v_ClientAdvertisementStatus.LastStateName IN('Failed')) AS 'Failed',(


v_ClientAdvertisementStatus


Status'SELECT COUNT(*) FROM v_ClientAdvertisementStatus WHERE .AdvertisementID=v_Advertisement.AdvertisementIDAND v_ClientAdvertisementStatus.LastStateName IN('Accepted - No Further )) AS 'Accepted - No Further Status',(


v_ClientAdvertisementStatusSELECT COUNT(*) FROM v_ClientAdvertisementStatus WHERE .AdvertisementID=v_Advertisement.AdvertisementIDAND v_ClientAdvertisementStatus.LastStateName IN('Retrying')) AS 'Retrying',(


v_ClientAdvertisementStatusSELECT COUNT(*) FROM v_ClientAdvertisementStatus WHERE .AdvertisementID=v_Advertisement.AdvertisementIDAND v_ClientAdvertisementStatus.LastStateName IN('Running')) AS 'Running',(


v_ClientAdvertisementStatusSELECT COUNT(*) FROM v_ClientAdvertisementStatus WHERE .AdvertisementID=v_Advertisement.AdvertisementIDAND v_ClientAdvertisementStatus.LastStateName IN('Waiting')) AS 'Waiting',
v_Advertisement.AdvertisementName AS 'Advertisement Name',
v_Advertisement
.AdvertisementID AS 'Advertisement ID' FROM v_AdvertisementINNERJOIN v_Package ON v_Advertisement.PackageID = v_Package.PackageIDINNER
v_CollectionJOIN v_Collection ON v_Advertisement.CollectionID = .CollectionIDINNER
v_ClientAdvertisementStatus JOIN v_ClientAdvertisementStatus ON v_Advertisement.AdvertisementID = .AdvertisementIDAND
V_advertisement v_Advertisement.AdvertisementID in(SELECT advertisementid FROM WHERE DATEDIFF(D, V_advertisement.presenttime,GETDATE())<=60) ORDER BY v_Advertisement.AdvertisementName

VM Ware Systems Collection Query

Collection: List of all Virtual machines and their Physical host System Name
List of all Virtual machines and their Physical host System Name

 
This report lists all the virtual machines and also adds the PhysicalHostName0 property. This tells you the name of the host server the virtual system is sitting on.
Here is the report syntax:

SELECT distinct SYS.Netbios_Name0, Gvm.PhysicalHostName0, SYS.User_Name0,
SYS.Resource_Domain_OR_Workgr0,OPSYS.Caption0 as C054, OPSYS.Version0, ENCL.Manufacturer0,
CSYS.Model0, Processor.MaxClockSpeed0, MEM.TotalPhysicalMemory0, WSTATUS.LastHWScan
FROM v_R_System SYS
LEFT JOIN v_GS_VIRTUAL_MACHINE  gvm ON SYS.ResourceID=gvm.ResourceID
LEFT JOIN v_RA_System_IPAddresses IPAddr on SYS.ResourceID = IPAddr.ResourceID
LEFT JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM.ResourceID
LEFT JOIN v_GS_COMPUTER_SYSTEM CSYS on SYS.ResourceID = CSYS.ResourceID
LEFT JOIN v_GS_PROCESSOR Processor on Processor.ResourceID = SYS.ResourceID
LEFT JOIN v_GS_OPERATING_SYSTEM OPSYS on SYS.ResourceID=OPSYS.ResourceID
LEFT JOIN v_GS_PC_BIOS BIOS on SYS.ResourceID=BIOS.ResourceID
LEFT JOIN v_GS_SYSTEM_ENCLOSURE ENCL on SYS.ResourceID=ENCL.ResourceID
LEFT JOIN v_GS_WORKSTATION_STATUS wSTATUS on SYS.ResourceID=WSTATUS.ResourceID
LEFT JOIN v_R_User USERS on SYS.User_Name0 = USERS.User_Name0
WHERE OPSYS.Caption0 is not null and CSYS.Model0 = 'Virtual Machine'
ORDER BY SYS.Netbios_Name0, SYS.Resource_Domain_OR_Workgr0