Jump to content


Established Members
  • Content Count

  • Joined

  • Last visited

  • Days Won


P@docIT last won the day on September 6 2014

P@docIT had the most liked content!

Community Reputation

5 Neutral

About P@docIT

  • Rank
    Advanced Member

Profile Information

  • Gender
  1. Figured it out. I didn't realize there were two params for deadline enforcement. -EnforcementDeadline -EnforcementDeadlineDay Clearly the latter (which I was using) only supports the date (day). I switched to the first one and I am getting the correct times now but the date is being increased by 7 days from the current day for some reason. (ex. today is 8/4, despite my script saying the deadline date should be 8/7 it makes it 8/11) Anyway, thanks for looking. Maybe this will help someone else. EDIT: Here is what I ended up with. Sets the correct date and time # Set Deadl
  2. Hello All, I have a Powershell script that I use to create multiple Software Update Deployments and it works perfectly (well almost). The last piece I'm missing is automating the deadline date. Currently I just have it getting the current date and adding 5 days. I then go into each deployments properties and change the date/time to the desired info. I've been trying to work out automating this a little bit by adding a variable for a static date/time. I can then change this date (time will always be the same) to the desired info at script run. Below is what I've come up with so far. The
  3. Ended up using VBS, works well. Option Explicit Dim objWMIService, objItem, colItems, strComputer, fso, WshShell, oExec On Error Resume Next strComputer = "." Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") Set colItems = objWMIService.ExecQuery("Select DriveType from Win32_LogicalDisk Where DeviceID = 'E:'") Set fso = WScript.CreateObject("Scripting.FileSystemObject") If Not fso.DriveExists("E:") Then Set WshShell = WScript.CreateObject("WScript.Shell") Set oExec = WshShell.Exec("setup.exe /s /v""/l*voicewarmup \""%temp%\besclientinstall.log\"" INST
  4. Thanks Peter. Removing the trailing backslash from the from the log path got rid of the 1622 error, but now I'm getting a 1203 error. Which appears to be: ERROR_NO_NET_OR_BAD_PATH The network path was either typed incorrectly, does not exist, or the network provider is not currently available. Please try retyping the path or contact your network administrator. 1203 (0x4B3)
  5. Afternoon all, I am trying to setup a simple script that will determine if Drive E: exists and if so is it a CD Rom drive. Then based on that info run install command line. The if else logic seems to work but I'm having a hard time getting the install cmd to run. Any help would be greatly appreciated, I'm also open to other ways of doing this. Exit code btw is 1622. Cheers, Mike $instdir = Get-WmiObject -Class Win32_LogicalDisk | Where-Object {$_.DeviceID -eq "E:"} If (!($instdir)){ $process = start-process -filepath "setup.exe" -argumentlist '/s /v"/l*voicewarmup \"%tem
  6. Thanks. Made that change so that won't happen again. Hopefully last question. I need some MOF help. So I added the McAfee mof using Sherry K.'s steps in this post http://www.myitforum.com/forums/Mcafee-mof-beginner-issues-m242989.aspx. The issue is that is only looking for HKEY_LOCAL_MACHINE\\SOFTWARE\\Network Associates\\ePolicy Orchestrator\\Application Plugins I need to add HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\Network Associates\\ePolicy Orchestrator\\Application Plugins Just now sure how to add, do i need to add a new section to the mof or can I just add a second Clas
  7. Oh man the new query is much better as it picks up all machines. My previous query was only picking up machines that had VSE installed this shows the status of all machines and teh NULL fields show as n/a. Perfect. Thanks again for all of your help. I picked up a tremendous amount of knowledge in our two days together.
  8. Not a dumb question at all because I believe that was it. So now that i'm aware of the DB drop down I think my focus was on that drop down when I attempted to scroll in another window, inadvertantly changing the DB.
  9. Not sure you can see in the screenshot that dbo.v_R_System_Valid shows up in the oblect explorer. So not sure, server might need a reboot.
  10. The multi-part identifier "RV.Netbios_Name0" could not be found. Along with all of the other items underlined in red in the screenshot. output error: Msg 208, Level 16, State 1, Line 1 Invalid object name 'dbo.v_R_System_Valid'. Hmm interesting. I plugged the sql that I worked on yesterday into sql and executed and I'm getting the same errors about dbo.v_R_System_Valid being an invalid object. I didn't change anything. Don't understand why it worked yesterday but not today. I'm using that same sql in report builder and execting the report seems ot be working.
  11. I get a bunch of errors with that code.
  12. So close... thought i found a solution for the null fields but it doesn't work, the query doesn't fail but it doesn't change the value. ISNULL(NULLIF(EPO.Version0,''),'Not Installed') AS 'Host Intrusion Prevention' SELECT a.[Computer Name],a.[McAfee VirusScan Enterprise],a.[McAfee Agent],b.[Host Intrusion Prevention],c.[EnCase Enterprise Agent] FROM (SELECT RV.Netbios_Name0 AS 'Computer Name', RV.ResourceID AS 'Resource', ARP.Version0 AS 'McAfee VirusScan Enterprise', EPO.Version0 AS 'McAfee Agent' FROM dbo.v_R_System_Valid RV INNER JOIN dbo.v_Add_Remove_Programs ARP ON RV.Re
  13. I think I got it. SELECT * FROM (SELECT RV.Netbios_Name0 AS 'Computer Name', ARP.Version0 AS 'McAfee VirusScan Enterprise', EPO.Version0 AS 'McAfee Agent' FROM dbo.v_R_System_Valid RV INNER JOIN dbo.v_Add_Remove_Programs ARP ON RV.ResourceID = ARP.ResourceID INNER JOIN dbo.v_GS_McAfeeEPO0 EPO ON RV.ResourceID = EPO.ResourceID WHERE ARP.DisplayName0 like '%VirusScan%' AND EPO.SoftwareID0 = 'EPOAGENT3000') a LEFT OUTER JOIN (SELECT RV.Netbios_Name0 AS 'Computer Name', EPO.Version0 AS 'Host Intrusion Prevention' FROM dbo.v_R_System_Valid RV INNER JOIN dbo.v_GS_McAfeeEPO
  14. Disregard... switched to your syntax, also noticed I had a typo in mine.
  • Create New...