why isnt this working (run on domain controller with domain admin priveleges)…
- User
why isnt this working (run on domain controller with domain admin priveleges) Get-WmiObject -Class "Win32_GroupUser" -ComputerName computer -Filter "GroupComponent='Win32_Group.Domain=""computer"",Name=""adminGroupName""'"
- Assistant
There are a few potential reasons this command may not be working:
- Ensure that you have correctly replaced "computer" with the actual name of the computer you are targeting.
- Make sure that "adminGroupName" is the actual name of the group that you are trying to retrieve users from.
- Check that you are running the command with the correct syntax and that all quotes and parentheses are properly closed.
- Verify that the user account you are using has the necessary permissions to access WMI data on the remote computer.
If you have checked all of these and the command still isn't working, please provide any error messages or additional details so that we can further assist you.
- User
excel if value in cell equal to text them delete row
- Assistant
To delete a row in Excel if the value in a specific cell equals a certain text, you can use a combination of the IF function and the Filter feature. Here is a step-by-step guide on how to achieve this:
-
Open your Excel spreadsheet and go to the sheet where you want to delete rows based on a specific text value.
-
Insert a new column next to the column containing the text values you want to check. Let's say the text values are in column A, and you want to delete rows where the text value is "DeleteMe," so insert a new column next to column A.
-
In the newly inserted column, use the following formula to check if the cell in column A equals "DeleteMe": =IF(A1="DeleteMe", "Delete", "")
-
Drag the fill handle (a small square at the bottom-right corner of the cell) down to apply the formula to all rows.
-
Select the range of cells in the newly inserted column where you have applied the formula.
-
Go to the "Data" tab on the Excel ribbon and click on the "Filter" button to enable filtering for the selected range.
-
Click on the drop-down arrow in the header of the newly inserted column and unselect the checkbox for the empty string.
-
Only the rows where the text value in column A is "DeleteMe" (marked as "Delete" in the inserted column) will be displayed. Select these rows.
-
Right-click on one of the selected row numbers and choose "Delete" from the context menu to remove the selected rows.
-
Once you have deleted the rows, you can turn off the filter by clicking on the "Filter" button on the "Data" tab again.
This process will allow you to delete rows in Excel based on a specific text value in a cell. Just make sure to adjust the column references and text value in the formula according to your specific requirements.
-