Microsoft Server OS Help

Hi EE,

I want to write a PowerShell export the contents of the following query:

openfiles /v /query  /fo CSV

Open in new window

So far I have:

$Session = New-PSSession -ComputerName SERVERNAME -ConfigurationName OpenShareFileSearch

$sb = {
    
    openfiles /v /query  /fo CSV | 
        select -skip 8 |
        ConvertFrom-Csv | 
}

Invoke-Command -Session $Session -ScriptBlock $sb |
     Export-Csv C:\temp\FileSearchResults.csv

Open in new window

I am getting the following error message:

[ict00441] Connecting to remote server failed with the following error message : The WinRM client sent a request to an
HTTP server and got a response saying the requested HTTP URL was not available. This is usually returned by a HTTP serv
er that does not support the WS-Management protocol. For more information, see the about_Remote_Troubleshooting Help to
pic.
+ CategoryInfo : OpenError: (System.Manageme....RemoteRunspace:RemoteRunspace) [], PSRemotingTransportExc
eption
+ FullyQualifiedErrorId : PSSessionOpenFailed
Invoke-Command : Cannot validate argument on parameter 'Session'. The argument is null or empty. Supply an argument tha
t is not null or empty and then try the command again.
At C:\temp\filename.ps1:10 char:24
+ Invoke-Command -Session <<<< $Session -ScriptBlock $sb |
+ CategoryInfo : InvalidData: (:) [Invoke-Command], ParameterBindingValidationException
+ FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.PowerShell.Commands.InvokeCommandCommand

Any assistance is welcome.

Thank you.

1 Comment

Bootstrap 4: Exploring New Features

LVL 12

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

LVL 1

Question by

dpacheco

12h ago

SBS 2011 workstations can use old Admin password

SBS 2011, admin password was changed, logged out and back into server with new password. The users are not administrators on their computers so someone with the admin password enters it when needed for an installation or download. The workstations are still able to use the old admin password, for how long I don't know but I'm assuming probably until the computer is restarted. Is there a way to avoid this?

4 Comments

LVL 1

Question by

CRL ltd

18h ago

Remove Terminal Server from domain

We have a client with a SBS2011 (the DC) box and a 2012 terminal Server (just a member). we are decommissioning the SBS2011 box but keeping the terminal server for the time being. is it possible for us to remove the TS from the domain, add it to a workgroup and use local user accounts for people to login with? the Remote licensing is installed on the terminal server itself. the logins are just managed via the SBS box.

2 Comments

Question by

Patrick Chapman

2d agoPrivate

Dynamic pointers in SSRS report

Need to find a to have summary and detail pointers in a bullet graph in sql server report builder 2008. My data comes in for a dynamic number of model types and need to have them as a pointer within a summary of all models pointer. I have done it statically but not where model count can change depending on what our plant is building.
BufferOverviewV2.pdf

0 Comments

LVL 27

Post by

Brian B

4d ago

MS Releases Updates to Fix January 2019 Patch Network Issues

https://www.ghacks.net/2019/01/09/windows-7-and-server-2008-r2-updates-kb4480970-and-kb4480960-causing-network-issues/

2 Comments

LVL 108

Expert Comment

by:John4d

The Windows 7 update out today and listed as an optional update fixes the invalid file handle error successfully. Requires a restart and blue screen "updating windows" message.

I have a folder mapped to my Windows 7 VM from my Windows 10 host.

Works, Fixed, Done. At least for now.

LVL 27

Author Comment

by:Brian B3d

Thanks for summarizing the title of my post.

LVL 1

Question by

sglee

6d agoSolved

Data.4096.dat files

Hi,
I have Windows Server 2012 Essentials and found this unfamiliar folder C:\ServerFolders\Client Computer Backups folder occupying over 700GB of space.
It consists of files from yesterday to April 2017 as you can see in two screenshots.
What are these files? Who is creating these files? Can I remove them?

Thanks.

7 Comments

In order to capture all computers in the domain on the new WSUS server, should I place a WSUS GPO just under the domain (like with the default domain policy)? Would that be a bad idea?

To note, I found 145 servers in AD using powershell with only 8 of them being disabled. Since yesterday, 45 have shown up on WSUS but they are in specific OUs where I linked the WSUS GPO. The other servers are in the Computers container and Domain Controllers OU (12 DCs). So, I am about 90 off between AD and WSUS (after I link the WSUS GPO to the Domain Controllers OU).

Thanks.

9 Comments

Visual Studio 2015, SSRS

I am having a problem working on RDL files locally. I was sent some RDL file to review. When I use "Add Existing" to add the reports to a report project, I can see the report design when I right-click and select "View Designer"

However, when I select "View Code", I only see XML. What am I doing wrong?

Thanks

7 Comments

LVL 17

Question by

MIKE

6d ago

SSRS How to Change FROM Email Address on Scheduled Report Emails?

Experts,

I have an SSRS server setup and we are currently scheduling nightly delivery (via EMAIL) of reports to clients.

The issue is that I would like to "dynamically" change the "FROM EMAIL" address for the out-going emails that contain the reports to a "Special EMAIL Address" for certain CLIENTS.
So for example, if I schedule a nightly report delivery via email for Customer "A", then I want EMAIL ADDRESS "A" to be included within the body of the email as the FROM email.

If I schedule a nightly report delivery via email for Customer "B", then I would like EMAIL ADDRESS "B" to be included within the body of the email as the FROM EMAIL.

Can someone help with HOW TO DO THIS?

Let me know if you have any questions.

Thanks
M

0 Comments

Hi, Just dropping this question again with some more detail to see if i can get a work around.

I am in the process of converting a large number of Crystal Reports to SSRS. I have hit a snag with a number of Running Total issues. we have over 25 reports that need to been converted but they all have a running total as a grand total, typically evaluating on group, outside of the group. In some cases these running values are used in other calculations. It is a nightmare.

As you can imagine I can not get this to work as if I write a running value expression on group it is outside of the group scope and does not work, and if i set the scope to "dataset1" the value is not correct as it needs to evaluate on group.

I have read through many links but i can't see how they will work, but i might just have a skill gap, none of them cover where the running total evaluating on group are used as a total only.

I have attached an example of one of the reports that has a running total, it is only one of the possible layouts and ways the previous reports used the running totals. but does highlight the issue i am hitting. If possible i would rather do this within the ssrs report but i am at a loss on how to get it to work.

We are on SQL 2014 but are about to migrate to 2016

Any ideas on a way to get this to work?

0 Comments

LVL 23

Question by

Mal Osborne

7d ago

How to get a Windows Server 2019 Demo running.

I am doing a server refresh soon. Plan is to get replacement RDS servers running Server 2019, to replace our aging 2008R2 boxes.

Since we have a heap of software in use, I am going through the testing process, checking that everything works, and figuring what to do with apps that do not. Will then pilot with a few users for a week for acceptance testing. I have downloaded and installed a copy of Server 2019 for this purpose.

Problem I am having now is with obtaining a key for the 2019 180day demo. The Microsoft Evaluation Centre originally had the ISO and keys on 2-Oct, but this was pulled a few days later. Now it just says "Following the launch of Windows Server 2019, we started the process of publishing the media for the 180-day evaluation media. In the process, we found an issue with the Eval media and are in the process of fixing it." Apparently the product can be purchased, and it available to volume licensing and MSDN users, but plebs still cannot obtain a key. The actual "issue" referred to was remedied weeks ago, and is irrelevant to us.

Any ideas where I can obtain a 180 day key for Server 2019?

I am NOT trying to do anything dodgy, illegal or unethical here, I just want to run a demo version and see what does not work.

2 Comments

Hi Experts,

We are using Dynamics CRM 2016 on prem. We have a subject tree built out in our CRM system that contains subject matters for Cases.

Our customer service people are in need of some reporting, and I think to get them the data they need I might need to use SSRS or Visual Studio, but if Advanced Find is an option I'm all for it because it gives them the ability to tweak their results on the fly without involving actually changing queries or reports. Avanced find is tempting, as it will let me use the UNDER option, which is kinda cool, but I don't think it does enough. It seems like I can only chose one subject matter at a time to report on.

Anyhow, they would like some reporting that captures each item we have listed as a subject.
They'd like this by year or by month and with a count of occurances.
So for example, I think they want something like this:

YR 2019
Vendor Issues 210
Personnel Issue 14
Bad venue experience 45
Guest Sickness 6
Complaint 178
Compliment 57
etc.

YR 2018
Vendor Issues 196
Personnel Issue 13
Bad venue experience 48
Guest Sickness 17
Complaint 92
Compliment 114
etc.

Yr 2017
Vendor Issues …

3 Comments

I'm a system administrator for Report Manager. I can see the users my folders, but cannot see the reports in the folder. I need to be able to see all the reports created in report builder in the user's my folder.

1 Comment

I need to create a report based on a sharepoint online list. When our sharepoint server was in house, this was not a problem but I cannot get the connection string to work for sharepoint online. I do not know power BI and frankly don't have time to learn it. If I can get SSRS to connect and I can get my report done in 1/2 hour. Anyone know the connection string to make this work?

4 Comments

Question by

jsgrosskopf

2019-01-10

cannot connect to sharepoint list

I am trying to write a ssrs report based on a sharepoint online list. I have tried about 100 different variations of the connection string with no luck. Can anyone point me in the right direction?

0 Comments

Hi,

I have a Windows 2012 R2 Hyper-V server with 3 VMs. One of the VMs is setup for Remote Desktop Services and we have about 13 users connect into this server to work. Most of them connect to it from within the office. Some of the users connect from outside of the office. The managers asked me if there's a way that I can restrict remote access for some of the users. They would be able to work at their computer within the office but if they go home and feel like they want to remote into their session, they would be restricted from logging into their session when they're out of the office. What's the best and most simple way to accomplish this? Thanks in advance for your help!

6 Comments

I'm executing a query inside SSRS and receiving an ORA-00933: SQL command not properly ended. It's just a SELECT statement but the error appears to be in the Where clause. Am I specifying the parameter, @PaperBill, incorrectly?

Select ACCTUSAGE_MAIN_V.BILLING_DATE
,ACCTUSAGE_MAIN_V.BILLING_CYCE
,ACCTUSAGE_MAIN_V.BILLING_MONTH
,ACCTUSAGE_MAIN_V.BILLING_YEAR
,ACCTUSAGE_MAIN_V.INVOICE_NUMBER
,ACCTUSAGE_MAIN_V.ACCOUNT_NUMBER
,ACCTUSAGE_MAIN_V.DESCRIPTION
,ACCTUSAGE_MAIN_V.CNT_LAST_NAME
,ACCTUSAGE_MAIN_V.CNT_FIRST_NAME
,ACCTUSAGE_MAIN_V.CNT_ADDR_1
,ACCTUSAGE_MAIN_V.CNT_ADDR_2
,ACCTUSAGE_MAIN_V.CNT_CITY
,ACCTUSAGE_MAIN_V.CNT_STATE
,ACCTUSAGE_MAIN_V.CNT_ZIP
,ACCTUSAGE_MAIN_V.CNT_ZIP_EXTEN
,ACCTUSAGE_MAIN_V.RECEIVE_PAPER_BILL
,ACCTUSAGE_MAIN_V.EMAIL
,ACCTUSAGE_MAIN_V.MIN_INVOICE_NUMBER
,ACCTUSAGE_MAIN_V.MAX_INVOICE_NUMBER
From COMIT_CUSTOM.TAMU_ACCTUSAGE_MAIN_V as ACCTUSAGE_MAIN_V
Where ACCTUSAGE_MAIN_V.RECEIVE_PAPER_BILL = @PaperBill
Order by ACCTUSAGE_MAIN_V.ACCOUNT_NUMBER,ACCTUSAGE_MAIN_V.BILLING_CYCE

3 Comments

Hi,
I have opened an RDL file in Visual Studio 8, when I preview the report, I get an error message “The selected Data Source cannot be found”.
When I go to the DataSource properties, it tells me to verify that the DataSource be included in the Project.
I do not have the rds file.

Within the Report Server Database I can see an entry for the Datasource in a table DataSource.
Is there someway I can extract this database entry into an rds file?
any guidance appreciated.
Thanks

4 Comments

We're looking for a simpler solution for controlling Windows updates on our 60 windows servers (some of which are Server 2016 which seem to have a mind of their own as to when they want to update themselves) .

As a new admin in my company, I'm working hard to learn lots of things but SCCM / ConfigMgr seems like a beast to learn.

The desktop guy uses it for the win10 desktop update (400 users in 6 locations). My boss doesn't want to use the same instance for servers because years ago, desktop updates were pushed to servers which trashed a bunch.

In my previous job, we used WSUS which seemed more manageable.

So, I'm looking for a simple solution for windows updates for servers without me needing to get a PHD in configmgr.

We're even open to 3rd party solutions if that would make it less painful.

I guess from a bandwidth perspective, downloading it once and updating from a local copy would be more efficient but since we just got a fatter internet connection, I'm even open to skipping that as a requirement if it would make it simpler.

Any thoughts would be very much appreciated.

Thanks,
Mike

4 Comments

OWASP: Forgery and Phishing

LVL 12

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

We currently use ADFS for authentication with some 3rd party hosted applications (i.e. Qualtrics). When our users hit the 3rd party site, they are redirected to our ADFS site where they are prompted to enter their AD credentials.

Is it possible to get those 3rd party sites to automatically login from domain joined computers using the credentials of the logged in user instead of having the user re-enter their credentials on the ADFS site? If so, how do we go about doing this? Is it something we can change on the ADFS setup, or do we need the 3rd party application vendor to support it and make some changes on their end?

3 Comments

Hi Experts,

I am using SSRS and I want to create a subtotal on based on the first 7 character of the AccountID field.

So the example attached, I would have a subtotal for the account 101-002-xx, 101-007-xx and 102-002-xx.

2 Comments

LVL 2

Question by

Technical Information

2019-01-04Solved

Microsoft Cluster File Server

Hi

What's the best way to failover a file server cluster? I need to take down the servers for maintenance separately but don't want any downtime.

Thanks

2 Comments

Question by

JPD153

2019-01-02Solved

Best configuration possible

Setting up a new Hyper V environment replacing SBS 2011
I have the opportunity to do a full setup of Windows 2019 server with Exchange 2019 to replace an aging SBS 2011.
I will need a new hardware platform and look for suggestions on the best practices:
1) Should the host OS be on an SSD rather than SAS 15K ? (it will be on a RAID 1 anyway and the Hyper V VMs will be on a RAID 5 or 10 depending on suggestions))
2) Should Active directory be on a VM or a physical machine ?
3) 2 or 3 VMs planned: 1 for Exchange, one for File and print sharing and may be another one for A/D depending on suggestions to 2)

7 Comments

Hello All,

I am using the following expression to calculate percentage in SSRS,
=Format(Fields!PCTanswers.Value/100,"0%")
however, sometime the calculated values aren't equal to 100% they are 99, so the rounding is not working correctly.
Can someone please help? Thanks.

3 Comments

ManagerID

ManagerName

WorkerTable

WorkerID

WorkerName

WorkerCategoryID

Category Table

CategoryID

CategoryName

ManagerWorker Table

ManagerID

Worker ID

The query results look like this:

ManagerID, ManagerName, WorkerID, WorkerName, CategoryID, CategoryName
1, JOE, 1, SAM, 1, Cat1
1. JOE, 2, BILL, 2, Cat2
1, JOE, 3, MIKE, 3, Cat3
2, ALAN, 1, SAM, 1, Cat1
2, ALAN, 4, ADAM, 2, Cat2
2, ALAN, 5, MARK, 2, Cat2…

1 Comment

Microsoft Server OS

Related Topics

Microsoft Server OS

Related Topics