This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Written by Jordan Hammond | |
###Define Variables | |
$autopath = "C:\Users\Public\Documents\Admin Arsenal\PDQ Deploy\Repository" | |
$autopackages = @() | |
$DBPath = "C:\programdata\Admin Arsenal\PDQ Deploy\Database.db" | |
###Build Package Objects | |
$test = New-Object psobject -Property @{ | |
Path = "\test" | |
ScheduleID = "12" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="utf-8"?> | |
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="17.1.0.0" MinimumVersion="3.1"> | |
<Report> | |
<ReportDefinition name="Definition"> | |
<RootFilter name="Filter"> | |
<Comparison>All</Comparison> | |
<Filters type="list"> | |
<ValueFilter> | |
<Table>WMIScanner_55_View</Table> | |
<TableTitle>WMI (Failed Updates)</TableTitle> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
Computers.Name AS "Computer Name" | |
, NetworkAdapterIPAddresses.Address AS "IP Address" | |
, NetworkAdapterIPAddresses.Subnet AS "Subnet Mask" | |
, NetworkAdapters.Name AS "Adapter Name" | |
, NetworkAdapters.NetConnectionId AS "Connection Name" | |
, NetworkAdapters.AdapterType AS "Adapter Type" | |
, NetworkAdapters.MacAddress AS "MAC Address" | |
, NetworkAdapters.NetConnectionStatus AS "Connection Status" | |
, NetworkAdapters.ConnectionSpeed AS "Connection Speed" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
Computers.Name AS "Computer Name" | |
, Computers.Model AS "Computer Model" | |
, Computers.Manufacturer AS "Computer Manufacturer" | |
, Computers.SerialNumber AS "Computer Serial Number" | |
, Computers.Memory AS "Computer Memory" | |
, CPUs.ProcessorSummary AS "CPU Processor" | |
, Computers.OS AS "Computer O/S" | |
, Computers.OSVersion AS "Computer O/S Version" | |
, Computers.OSServicePack AS "Computer SP / Release" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
Computers.Name AS "Computer Name" | |
, LogicalDisks.LogicalDeviceId AS "Drive Letter" | |
, ( (LogicalDisks.Size - LogicalDisks.FreeSpace) / 1024 / 1024 / 1024 ) AS "Used Space GB" | |
FROM | |
Computers | |
INNER JOIN | |
LogicalDisks USING (ComputerId) | |
WHERE | |
<ComputerFilter> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="utf-8"?> | |
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="17.1.0.0" MinimumVersion="4.0"> | |
<Collection> | |
<ReportDefinition name="Definition"> | |
<RootFilter name="Filter"> | |
<Comparison>Any</Comparison> | |
<Filters type="list"> | |
<GroupFilter> | |
<Comparison>All</Comparison> | |
<Filters type="list"> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="utf-8"?> | |
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="17.1.0.0" MinimumVersion="3.1"> | |
<Report> | |
<ReportDefinition name="Definition"> | |
<Sql>-- Created by Colby Bouma for: https://old.reddit.com/r/pdq/comments/bty5po/request_wmi_query_check_if_user_is_local/ | |
SELECT | |
Computers.Name AS "Computer Name" | |
, Computers.CurrentUser AS "Current User" | |
, LocalGroupMembers.UserName AS "Local Group Member Username" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="utf-8"?> | |
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="16.6.0.8" MinimumVersion="15.0"> | |
<CustomTool> | |
<CredentialsId value="null" /> | |
<ScanAfter>DoNotScan</ScanAfter> | |
<ScanProfileId value="null" /> | |
<SuccessCodesText>0</SuccessCodesText> | |
<Timeout>00:03:00</Timeout> | |
<WakeOnLan value="false" /> | |
<CustomToolType>Local</CustomToolType> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="utf-8"?> | |
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="17.0.2.0" MinimumVersion="3.1"> | |
<Report> | |
<ReportDefinition name="Definition"> | |
<RootFilter name="Filter"> | |
<Comparison>All</Comparison> | |
<Filters type="list" /> | |
</RootFilter> | |
<ReportDefinitionTypeName>BasicReportDefinition</ReportDefinitionTypeName> | |
<Columns type="list"> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="utf-8"?> | |
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="17.0.3.0" MinimumVersion="4.0"> | |
<Collection> | |
<ReportDefinition name="Definition"> | |
<RootFilter name="Filter"> | |
<Comparison>All</Comparison> | |
<Filters type="list"> | |
<ValueFilter> | |
<Table>File</Table> | |
<TableTitle>Files & Directories</TableTitle> |