<div>
Script is fantastic, only problem is masvc is the new McAfee agent, some machine have the older agent which is the *McAfeeFramework*, and both don't really exist simultaneously
</div>

<div>
apologies just checked the spreadsheet and they appearing on their
</div>

<div>
how do I color code the results on excel, the first set of results I want it in one colour example blue the next white then blue again
</div>

<div>
also the service information is outputting to the csv file only and not the powershell window???
</div>

<div>
also the machines that do not ping, I need to record those results in the spreadsheet, how do I do this?
</div>

<div>
If you want the info just in the console, remove the Export-CSV command. 
 
Writing to an .XLSX file instead of a .CSV is much more complicated, and involves working with Excel COM objects. &nbsp;Sorry, but I don't have time to do all that. 
 
Here's a modification with the non-pinging result added to the output file. 

<pre><code class="code-10 nolinks" id="code-20-42048088-1">$inputFiles = &quot;.\LondonComps.txt&quot;, &quot;.\Singaporecomps.txt&quot;, &quot;.\usacomps.txt&quot;, &quot;.\RomaniaComps.txt&quot;
$outputFile = &quot;result.csv&quot;
Get-Content $inputFiles | ForEach `
{
 $Server = $_
 if (Test-Connection -ComputerName $Server -Count 2 -Quiet ) {
 If ( $services = Get-Service *masvc*, *entercept*, *McAfeeFramework* -ComputerName $Server )
 {
 $services | Select Status, DisplayName, Machinename
 }
 Else
 {
 &quot;&quot; | Select @{n=&quot;Status&quot;;e={&quot;Services not found&quot;}}, @{n=&quot;DisplayName&quot;;e={&quot;McAfee Services&quot;}}, @{n=&quot;Machinename&quot;;e={$Server}}
 }
 }
 else 
 {
 &quot;&quot; | Select @{n=&quot;Status&quot;;e={&quot;Couldn't ping server&quot;}}, @{n=&quot;DisplayName&quot;;e={&quot;&quot;}}, @{n=&quot;Machinename&quot;;e={$Server}} 
 }
} | Export-Csv $outputFile -NoTypeInformation
</code></pre>
</div>

<div>
Hi, 
 
I am getting this error for some machines: 
 
Get-Service : Cannot open Service Control Manager on computer 'PC-ROM-1026'. This operation might require other privileges. 
At line:14 char:18 
+ If ( $services = Get-Service *entercept* -ComputerName $Server ) 
+ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: NotSpecified: (:) [Get-Service], InvalidOperationException 
&nbsp; &nbsp; + FullyQualifiedErrorId : System.InvalidOperationException,Microsoft.PowerShell.Commands.GetServiceCommand 
 
how do I add this to the report, I want a field with machines that I could not connect to due to the above.
</div>

<div>
also I need to know which machine belong to which content, $inputFiles = &quot;.\LondonComps.txt&quot;, &quot;.\Singaporecomps.txt&quot;, &quot;.\usacomps.txt&quot;, &quot;.\RomaniaComps.txt&quot;. 
 
Is there a way I can this to the csv?
</div>

<div>
Sorry, but you can't keep on adding requirements. &nbsp;Error handling and accounting for all kinds of scenarios can easily double or triple the amount of code. &nbsp;This the last modification I'll do. &nbsp;If you need something additional, please open a new question. 

<pre><code class="code-10 nolinks" id="code-20-42051698-1">$inputFiles = &quot;.\LondonComps.txt&quot;, &quot;.\Singaporecomps.txt&quot;, &quot;.\usacomps.txt&quot;, &quot;.\RomaniaComps.txt&quot;
$outputFile = &quot;result.csv&quot;
$inputFiles | ForEach `
{
 $file = $_

 Get-Content $file | ForEach `
 {
 $Server = $_
 if ( Test-Connection -ComputerName $Server -Count 2 -Quiet )
 {
 Try
 {
 If ( $services = Get-Service *masvc*, *entercept*, *McAfeeFramework* -ComputerName $Server )
 {
 $services | Select Status, DisplayName, Machinename,
 @{n=&quot;SourceFile&quot;;e={$file}}
 }
 Else
 {
 &quot;&quot; | Select @{n=&quot;Status&quot;;e={&quot;Services not found&quot;}},
 @{n=&quot;DisplayName&quot;;e={&quot;McAfee Services&quot;}},
 @{n=&quot;Machinename&quot;;e={$Server}},
 @{n=&quot;SourceFile&quot;;e={$file}}
 }
 }
 Catch
 {
 &quot;&quot; | Select @{n=&quot;Status&quot;;e={&quot;Error checking services&quot;}},
 @{n=&quot;DisplayName&quot;;e={&quot;&quot;}},
 @{n=&quot;Machinename&quot;;e={$Server}},
 @{n=&quot;SourceFile&quot;;e={$file}}
 }
 }
 else 
 {
 &quot;&quot; | Select @{n=&quot;Status&quot;;e={&quot;Couldn't ping server&quot;}},
 @{n=&quot;DisplayName&quot;;e={&quot;&quot;}},
 @{n=&quot;Machinename&quot;;e={$Server}},
 @{n=&quot;SourceFile&quot;;e={$file}}
 }
 }
} | Export-Csv $outputFile -NoTypeInformation
</code></pre>
</div>

<div>
my apologies, thank you for all the help.
</div>

<div>
<div class="content wysiwyg-content">
Hi Guys, 
 
I have written the script below to check all machines in our asset register that they have McAfee agent and hips installed, any suggestions for improvement will be greatly appreciate: 
 

<pre><code class="code-10 nolinks" id="code-10-29008708-1">$ServerName = Get-Content .\LondonComps.txt, .\Singaporecomps.txt, .\usacomps.txt, .\RomaniaComps.txt

foreach ($Server in $ServerName) { 
 
 if (Test-Connection -ComputerName $Server -Count 2 -Quiet ) { 
 
 write-Host &quot;$Server is alive and Pinging &quot; -ForegroundColor Green 

		Get-Service *masvc*, *entercept*, *McAfeeFramework* -ComputerName $Server | select Status, DisplayName, Machinename
		
 
 } else 
 
 { Write-Warning &quot;$Server seems dead not pinging&quot; 
 
 } 

 
 
}
</code></pre>
 
I want the results to be on Microsoft excel on whether the service is running or not which will indicate that the product is installed on the machine or not. please help I am unsure how to do this. 
 
thank you in advance, 
Kay
</div>
</div>

Hi Guys, 

I have written the script below to check all machines in our asset register that they have McAfee agent and hips installed, any suggestions for improvement will be greatly appreciate:

(CODE)

I want the results to be on Microsoft excel on whether the service is running or not which will indicate that the product is installed on the machine or not. please help I am unsure how to do this. 

thank you in advance, 
Kay

Powershell script reporting

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Anti-virus software was originally developed to detect and remove computer viruses. However, with the proliferation of other kinds of malware, antivirus software started to provide protection from other computer threats. In particular, modern antivirus software can protect from malicious browser helper objects (BHOs), browser hijackers, ransomware, keyloggers, backdoors, rootkits, trojan horses, worms, malicious layered service providers (LSPs), dialers, fraud tools, adware and spyware. Some products also include protection from other computer threats, such as infected and malicious URLs, spam, scam and phishing attacks, online identity theft (privacy), online banking attacks, social engineering techniques, Advanced Persistent Threat (APT), botnets and DDoS attacks.