Posts made by jayrob86

@Wayne-Workman said in General Question - downloading inventory Automated:

Probably easier to just query the DB directly using the fogstorage MySQL account. Putting together a CSV is pretty easy. I don’t know how to do it in powershell, but in BASH it’s easy to do. I can help with that, but I didn’t want to go script that until you responded saying that would work for you.

@Wayne-Workman thanks for offering a better solution I actually think that this would work better. If you could provide a bit of insight how to query the database I think it would work best.
Thanks for your assistance.
If you can post the bash version I will work on the powershell version and share it as well.

This is more of a general question, but I am trying to see if anyone would know a way to download the inventory as CSV. I am trying to automate this and was thinking powershell

$username = "user"
$password = "pass"
 
$ie = New-Object -com InternetExplorer.Application
$ie.visible=$true
$ie.navigate("url.lsps.org")
while($ie.ReadyState -ne 4) {start-sleep -m 100}
$ie.document.getElementById("username").value= "$username"
$ie.document.getElementById("password").value = "$password"
Start-Sleep -m 100
$ie.document.getElementById("login-form-submit").click()
Start-Sleep -s 4
$ie.Navigate('http://fogserver.org/fog/management/?node=report&sub=inventory')
Start-Sleep -s 4
$ie.Navigate('http://fogserver.org/fog/management/export.php?type=csv')

I can get this work in IE 11 but then I get a popup asking to save and I can’t figure out a way to stop this and my google-fu didn’t provide much luck. I can get all the elements and tags needed via this below snippet, but I am not sure how to input the data:

$inv = Invoke-WebRequest 'fogserver.org' 
$inv.ParsedHtml.getElementById("username")
$inv.ParsedHtml.getElementById("password").value= "password"
$inv.ParsedHtml.getElementById("login-form-submit").click()

Any help is greatly appreciated.

Thanks,

@JJ-Fullmer this is awesome thank you for sharing your knowledge and scripts.

@Wayne-Workman said in Image Prep Script:

@JJ-Fullmer said in Image Prep Script:

pnputil

Can you tell us more about that? I’m thinking I’m going to have to build a universal image now.

PNP Utility can install drivers that match the hardware for the device.
Here is an article that I found that discusses using PNPutil and Forfiles.

https://deploymentbunny.com/2011/05/07/adding-drivers-using-pnputil-and-forfiles/
https://deploymentbunny.com/2016/02/26/powershell-is-king-export-drivers-from-windows/ link text

@JJ-Fullmer would you mind sharing howith you are able to have a firstlogin and Setup Complete without sysprep. I am thinking of using the pnputil to install driver cabs after PC is imaged.

Re: Deploying a single golden image to different hardware with FOG

Have you tried this for Windows 10 ? If so do you still recommend to use the WinPE 3.0 drivers? Or would you suggest 10.0

Thanks,

@george1421 thanks do you know where I could look to verify? In the function.sh?

I have been reading all the posts and comments discussing the use of post download scripts and really think that this feature seems amazing. I was not the one that build our fogserver, but I do know that is on version 1.20. I do not see a postinstallscripts folder, if I just create this folder will this work? I really want to use this for automatic drivers, buy the model name. Arch, Manufacturer.

Thanks,