How can I change "+ New Item" in a custom list
I have several custom lists and in some cases being able to change the text above the list " + new item" to a different text to make it more logical for users is needed. Currently I need to change it to "Create New Access Request". I have read a lot of blogs and posts here, but they all have one problem, they assume the person asking the question has years of programming in SharePoint. I have tried using Content Editors and SharePoint Designer but in each case it seems I am missing something that I know has to be experience knowledge. Does anyone have a process that they can share, that is step by step?
Thanks. Newbie Joel
Reply:
One way you can achieve is by injecting the script on the page.
Follow the article below for Step by Step instructions. Since you are using SharePoint 2013, scroll all the way down on the page and you will see snippet for SharePoint 2013.
http://www.sharepointdiary.com/2013/02/change-add-new-item-link-text.html
Also use Script Editor web Part instead of Content Editor web part. Steps to add Script Editor web part remains the same as adding Content Editor. i.e. Edit Page --> Click Add a Web Part link on the page --> This will open add web part section in the Ribbon. --> Scroll down on the categories until you see Media and Content --> Click on it --> Select Script Editor Web Part --> Click ADD button at the bottom right corner.
Amit
------------------------------------
Reply:
Amit,
Thanks. I figured out the Script Editor vs Content Editor, but the code was still giving me issues. One things was, I could see "+new item" appear and then be replaced with "Create New Access Request". I found another piece of code that seems to work cleaner, though being a novice, not sure if it is as efficient. Also, for anyone trying this after me, you do have to add the Script Editor snippet to each view you want to change.
SharePoint 2013 Script Editor Snippet:
<script type="text/javascript">
$(document).ready(function() {
$("#idHomePageNewItem").text('Create New Access Request');
});
</script>
------------------------------------
Online Newspaper Website
Hey Guys,
I want to develop a online Newspaper in my regional language and I'm using ASP.Net MVC Technology Now,My question is my regional language needs another application for typing the literature which isn't English and like i said earlier the content of the news paper will be in my regional language. so how do i connect my regional language literature typing application to my project and post the content online?It'd be great if someone helps me out on this issue.Hoping for the best,Thank you in Advance.
- Edited by Lalith Prasad Monday, January 16, 2017 2:18 AM
- Moved by Xujun Zhao Thursday, January 19, 2017 1:49 AM
Reply:
Hi Lalith,
Please consider posting MVC related questions to https://forums.asp.net/1146.aspx/1?MVC.
Best Regards,
Xujun Zhao
MSDN Community Support<br/> Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href="mailto:MSDNFSF@microsoft.com">MSDNFSF@microsoft.com</a>.
------------------------------------
Reply:
------------------------------------
OStress Replay - We are trying to benchmark performance of Azure S
BUG? Server 2016 Standard w/ Desktop; Admin RDP session shadow console error. Please advise/fix!!!
From administrative command prompt withing remote desktop session on Server 2016 host:
"mstsc -shadow:1 -control -noconsentprompt"
Works as expected but only once! If you close the shadow session you cannot get it back without a reboot. This is the resulting error if you try again to shadow the console session:
- Moved by Amy Wang_ Thursday, January 19, 2017 8:23 AM https://support.microsoft.com/nl-be/help/3200967/changes-to-remote-connection-manager-in-windows-server-2016
Reply:
- Edited by erblock Wednesday, January 18, 2017 9:54 AM
------------------------------------
VB.net does not add all the fields from ServiceNow webservice
I am able to add webservice from ServiceNow (ticketing tool).
But it wont add all the fields that are provided by ServiceNow, as other SOAP tools (SOAPUI).
VB.net wont allow me to pass the 'displayvalue=all' to the SOAP endpoint so that all the fields are accessible/displayed.
I want VB.net to pass https://cibitsm.service-now.com/incident_sla.do?SOAP&displayvalue=all to the webservice,
but it only passes: https://cibitsm.service-now.com/incident_sla.do?SOAP
I do not know where to change these in Webrefernce code generated by
Microsoft.VSDesigner
Please help!!
- Moved by Sara LiuMicrosoft contingent staff Friday, January 27, 2017 7:32 AM
Reply:
Hi RafiQ_MD,
Welcome to the MSDN forum.
Since your issue is about the development of the ServiceNow tool, and our forum is to discuss Visual Studio WPF/SL Designer, Visual Studio Guidance Automation Toolkit, Developer Documentation and Help System, and Visual Studio Editor, it is better to redirect to the ServiceNow Community forum for dedicated information, you will get a more professional support from there, thank you for your understanding.
I found a ServiceNow product documentation: Direct Web Services and may be you can have a look at, see if it is helpful or not.
Best regards
Sara
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
------------------------------------
Insider Preview Build 15002 ISO is available to download now
Use the following link to download your 15002 iso file.
Windows Insider Preview Downloads
Who will be crowned the First PowerShell Guru of 2017!!
Time for a fresh start!
[The Guru is the means of realisation. "There is no knowledge without a teacher."]
We're looking for the first Gurus of 2017!!
All you have to do is add an article to TechNet Wiki from the field of your interest. Something that fits into one of the categories listed on the submissions page. Copy in your own blog post, a forum solution, a white paper, or just something you had to solve for your own day's work today.
A snippet you share can make you a January 2017 TechNet Wiki Guru in your favorite category and this is official Microsoft TechNet recognition!
HOW TO WIN
Please copy over your Microsoft technical solutions and revelations to TechNet Wiki.
Add a link to it on THIS WIKI COMPETITION PAGE (so we know you've contributed).
Every month, we will highlight your contributions, and select a "Guru of the Month" in each technology.
If you win, we will sing your praises in blogs and forums, similar to the weekly contributor awards. Once "on our radar" and making your mark, you will probably be interviewed for your greatness, and maybe eventually even invited into other inner TechNet/MSDN circles!
Winning this award in your favorite technology will help us learn the active members in each community.
Feel free to ask any questions below.
More about TechNet Guru Awards.
 | Ronen Ariely [Personal Site] [Blog] [Facebook] [Linkedin] |
Reply:
1 article so far:
- Azure RBAC Management Tool - Manage and Control your organization access to Azure accounts by Avihai Hajaj
And 14 more days to go!
Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!
------------------------------------
Who will be crowned the First Windows Server Guru of 2017!!
Time for a fresh start!
[The Guru is the means of realisation. "There is no knowledge without a teacher."]
We're looking for the first Gurus of 2017!!
All you have to do is add an article to TechNet Wiki from the field of your interest. Something that fits into one of the categories listed on the submissions page. Copy in your own blog post, a forum solution, a white paper, or just something you had to solve for your own day's work today.
A snippet you share can make you a January 2017 TechNet Wiki Guru in your favorite category and this is official Microsoft TechNet recognition!
HOW TO WIN
Please copy over your Microsoft technical solutions and revelations to TechNet Wiki.
Add a link to it on THIS WIKI COMPETITION PAGE (so we know you've contributed).
Every month, we will highlight your contributions, and select a "Guru of the Month" in each technology.
If you win, we will sing your praises in blogs and forums, similar to the weekly contributor awards. Once "on our radar" and making your mark, you will probably be interviewed for your greatness, and maybe eventually even invited into other inner TechNet/MSDN circles!
Winning this award in your favorite technology will help us learn the active members in each community.
Feel free to ask any questions below.
More about TechNet Guru Awards.
| | Ronen Ariely [Personal Site] [Blog] [Facebook] [Linkedin] |
- Changed type pituachMVP Wednesday, January 4, 2017 4:23 AM
Reply:
No Windows Server articles yet!
14 days to go!
Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!
------------------------------------
Who will be crowned the First Windows Server Guru of 2017!!
Time for a fresh start!
[The Guru is the means of realisation. "There is no knowledge without a teacher."]
We're looking for the first Gurus of 2017!!
All you have to do is add an article to TechNet Wiki from the field of your interest. Something that fits into one of the categories listed on the submissions page. Copy in your own blog post, a forum solution, a white paper, or just something you had to solve for your own day's work today.
A snippet you share can make you a January 2017 TechNet Wiki Guru in your favorite category and this is official Microsoft TechNet recognition!
HOW TO WIN
Please copy over your Microsoft technical solutions and revelations to TechNet Wiki.
Add a link to it on THIS WIKI COMPETITION PAGE (so we know you've contributed).
Every month, we will highlight your contributions, and select a "Guru of the Month" in each technology.
If you win, we will sing your praises in blogs and forums, similar to the weekly contributor awards. Once "on our radar" and making your mark, you will probably be interviewed for your greatness, and maybe eventually even invited into other inner TechNet/MSDN circles!
Winning this award in your favorite technology will help us learn the active members in each community.
Feel free to ask any questions below.
More about TechNet Guru Awards.
| | Ronen Ariely [Personal Site] [Blog] [Facebook] [Linkedin] |
Reply:
No Windows Server articles yet!
14 days to go!
Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!
------------------------------------
Who will be crowned the First Windows Server Guru of 2017!!
Time for a fresh start!
[The Guru is the means of realisation. "There is no knowledge without a teacher."]
We're looking for the first Gurus of 2017!!
All you have to do is add an article to TechNet Wiki from the field of your interest. Something that fits into one of the categories listed on the submissions page. Copy in your own blog post, a forum solution, a white paper, or just something you had to solve for your own day's work today.
A snippet you share can make you a January 2017 TechNet Wiki Guru in your favorite category and this is official Microsoft TechNet recognition!
HOW TO WIN
Please copy over your Microsoft technical solutions and revelations to TechNet Wiki.
Add a link to it on THIS WIKI COMPETITION PAGE (so we know you've contributed).
Every month, we will highlight your contributions, and select a "Guru of the Month" in each technology.
If you win, we will sing your praises in blogs and forums, similar to the weekly contributor awards. Once "on our radar" and making your mark, you will probably be interviewed for your greatness, and maybe eventually even invited into other inner TechNet/MSDN circles!
Winning this award in your favorite technology will help us learn the active members in each community.
Feel free to ask any questions below.
More about TechNet Guru Awards.
| | Ronen Ariely [Personal Site] [Blog] [Facebook] [Linkedin] |
Reply:
No Windows Server articles yet!
14 days to go!
Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!
------------------------------------
Windows 10 - Wallpaper keeps disapearing and moving desktop icons, after enabling folder redirection
We just started testing the folder redirection group policy on windows 10 computers currently joined to windows domain. At first, everything was nice and happy valley.
But, just a day after, we started to receive complaints from the users using the testing computers that their wallpapers were disappearing, and the desktop icons were moving from their prefer location to another location on the desktop.
Nothing on the network has changed, and the windows 10 have not received any new updates of any kind, drivers or security updates, etc.
Can anyone share if there is a fix or is this something that Microsoft has not fixed? Looking at older forums, it seems folder redirection and user loosing personalize settings has been an issue for a very long time.
Any help or suggestion is always gladly appreciated.
Thanks
- Edited by PedroRobles Friday, September 16, 2016 1:30 PM
Reply:
Enter the following directory:
%USERPROFILE%\AppData\Local
Find the IconCache.db file, and rename it as IconCache.db.old.
Close the window, and restart the computer.
S.Sengupta, Windows Insider MVP
------------------------------------
Script to check the access of a particular user account in AD on particular day
Hi Team,
Is it possible to find through a script to identify that a particular user account been accessed in Active Directory... couple of weeks before..
Because that particular user is in thinking that his account is been compromised
Thanks in Advance
Thanks & and regards S.Swaminathan Live & and let others live!!!
- Changed type Bill_Stewart Friday, February 17, 2017 7:10 PM
- Moved by Bill_Stewart Friday, February 17, 2017 7:10 PM Unanswerable drive-by question
Reply:
What does "identify that a particular user account been accessed in Active Directory" mean, specifically?
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
Unless you have auditing enabled, you can only check the lastLogon attribute of the user. This attribute is not replicated. A different value for the user is saved on every DC. You must query all DCs in the domain and keep track of the largest (latest) value. But this will also reveal which DC last authenticated the user, which will indicate the site. The bigger problem is that the value will be overwritten the next time the DC authenticates the user. Really the best hope is that the intruder authenticated on a different DC than the one normally used by the user, so the value is not overwritten. Or you need to query soon after the intrusion.
Perhaps auditing is the best option, but this won't help for past intrusions that happened before you configured to audit logons.
Edit: I would link scripts for this, but all the ones I know of output the last logon for all users. You need the last logon for a specific user on each DC, to see if any look suspect.
Richard Mueller - MVP Enterprise Mobility (Identity and Access)
- Edited by Richard MuellerMVP Tuesday, January 17, 2017 6:34 PM
------------------------------------
Reply:
Thanks & and regards S.Swaminathan Live & and let others live!!!
------------------------------------
Reply:
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
Thanks for Richard & Bill to share your expertise here, Since the audit logs are being overwritten due to the limitation in the space configured in our Domain Controllers , I have sought the help of QRADAR team to check the logs
Thanks & and regards S.Swaminathan Live & and let others live!!!
------------------------------------
cpu and duration for very long query commands
Entity Framework (EF) sometimes issues very long SQL commands, we currently have two that are over 300k bytes long.
It's amazing that these can execute as quickly as they do, but I'm curious whether the cpu and duration times reported on profiler include the time to receive and parse the command.
Even if they are parameterized, 300k+ commands can take a while to check, these are taking about 100 milliseconds to 300 milliseconds on my (fairly fast) workstation. They are only doing a few hundred logical reads and probably no physical reads - unless from tempdb, I have not actually extracted and rerun the commands to see. They return very little actual data.
Thanks,
Josh
- Changed type Lin LengMicrosoft contingent staff Tuesday, January 17, 2017 6:22 AM more discussion than question
Reply:
Hello Josh,
I'm about to go to bed and I do not know a documentation about this by heart. I just wanted to add what I know about this and EF.
From my experience, I can say that the compilation time is included into the calculation, but mind you, it's done only once if a query / SP is cached.
Once I was on a client site, recently and they were using EF. Some queries were really really long and it was taking about an hour to complete for a "route planning" work. We worked on the query with the developers and I realized that most of the query was rubbish, there were lots of unnecessary UNIONs. We took them out, with a lot of unnecessary columns and then we turn the query into an SP. Then it was taking much much less. Especially for complicated queries, I think, EF sucks. Those queries must be written manually, basic ones are generally alright.
http://ekremonsoy.blogspot.com | http://www.ekremonsoy.com | @EkremOnsoy
------------------------------------
Reply:
Hi Ekrem,
I've seen and "mitigated" some long EF queries before, but only ones that were taking many seconds, this is the first time I've looked at huge queries that "only" were wasting a few tenths of a second.
Actually I had another one here the other day, taking 12 seconds of cpu (4 seconds duration with parallel plan), and a rewrite to an SP took it down to 12 *milliseconds*. Wouldn't surprise me if I could reduce these new huge ones too - heck, could probably put in a pretest that would eliminate them entirely most of the time.
Our developers "like" their EF but we also have a mission to scale, so we're looking for these and cleaning them up as we find them.
Lots of unnecessary unions, and of course tons of unnecessary aliasing as well, if they cleaned up just the aliasing they could probably reduce the average lengths by 2/3 - not to mention making them much more human-readable.
Thanks,
Josh
------------------------------------
Reply:
Ekrem is correct - the duration is the parse, compile and execute time that is reported in profiler.
Can we see an example of the mangled EF query?
------------------------------------
Reply:
Ekrem is correct - the duration is the parse, compile and execute time that is reported in profiler.
Can we see an example of the mangled EF query?
I suppose so, we haven't even put the replacement in yet, we're still generating them. I'll try to post one someplace I can link to on Tuesday, need a little time to sanitize the table and field names.
I think you can find similar examples on virtually any medium to large scale C#/EF application, it's a matter of understanding what the actual semantics are and what the real work being done is, then typically it's easy to write a clean equivalent. EF statements are mostly amazingly efficient, especially given their verbosity, but, well, some just aren't. Keeps database architects and tuners busy.
Josh
------------------------------------
Reply:
------------------------------------
Reply:
>The problem is you can't really re-write them, you need to get the dev's to use stored procedures to replace the EF calls.
Yes, that's how you typically "re-write" them. And note that net/net EF is still a big win, as it allows developers to write the application without knowing TSQL, even if a SQL expert has to re-write some of the queries later.
And EF does a really good job of creating SQL tables to match your entity model. Very few devs or DBAs are actually good at SQL data modeling. So replacing SQL Server data modeling with C# entity modeling makes a lot of sense for many teams.
Dapper is good too, but it's different. It's just a modern data access helper library, rather than an ORM. You still have to write your own SQL queries.
David
Microsoft Technology Center - Dallas
My Blog- Edited by davidbaxterbrowneMicrosoft employee Saturday, January 14, 2017 5:12 PM
------------------------------------
Reply:
>And EF does a really good job of creating SQL tables to match your entity model.
I've never yet seen it used that way except to allow it to create little state tables and such, but I mostly work large projects with multiple "full stack" developers.
First I've heard of "Dapper".
I have seen EF tuned up, I located some obnoxious thing EF was doing (I can't even recall the specifics), and one of the EF experts went in and diddled it and made it all good. I think the boss in my current situation wants to try some of that before using my SP. They're just not fond of SPs here. I have had to replace some EF because we needed some locking hints to avoid deadlocks, but instead of (trivial) SPs we're using explicit SQL sent from the app.
Josh
------------------------------------
Reply:
I agree on bad aliasing - did you try proposing a shorter alias in EF? If you do, can you post a link, so I can vote?
We're also using EF here - and for updating multiple tables I prefer to use stored procedures rather than EF. For some queries involving joins I also prefer direct queries or views instead of LINQ to EF.
For every expert, there is an equal and opposite expert. - Becker's Law
My blog
My TechNet articles
------------------------------------
Question
I have a server 2008 R2 which is also a 2010 exchange server and a dns, ad. I have created a new dc 2012 R2 and transferred all roles, have not raised the forest level, but the new dc is the DHCP server as well and the primary DNS.
Exchange will be migrated to a 2016 exchange server sitting in its own VM. The client wants to keep the same IP address of the 2008R2 DC which will be decommissioned. I see underling issues with keeping the IP around, even though the AD meta data is cleaned out, there is still risk of that IP laying around somewhere in AD.
Any thoughts?
Reply:
------------------------------------
Searching by DisplayName filed with ContainsSubstring filter does not work
Hi,
I am using Office365 and EWS for searching contacts in the WellKnownFolderName.Contacts folder (Microsoft.Exchange.WebServices.Data.Folder.FindItems(SearchFilter searchFilter, ItemView view)).
I am trying to find and to filter contacts with SearchFilter.ContainsSubstring filter by display name (ContactSchema.DisplayName) field,
but somehow it use ContainmentMode.PrefixOnWords filter for DisplayName.
I have no this problem with ContactSchema.GivenName, ContactSchema.MiddleName, ContactSchema.Surname fileds.
The "ContainsSubstring" filters works fine for these fields, but not for DisplayName.
If I try to search by all fields together ContactSchema.GivenName, ContactSchema.MiddleName, ContactSchema.Surname and ContactSchema.DisplayName with SearchFilter.ContainsSubstring filter,
then SearchFilter.ContainsSubstring are replaced with ContainmentMode.PrefixOnWords for all fields!
so, there are questions I have
1. Why the ContainsSubstring filter (with ContainmentMode.Substring) does not work for DisplayName?
2. Why ContainsSubstring does not work for any field when ContainsSubstring filter are presented for DisplayName?
Thanks
Since upgrade to Windows 8, cannot save .rdp files under the Remote Desktop Connection application on the Desktop
Since I upgraded to Windows 8, I am no longer able to save individual Remote Desktop Connection files as .rdp files. I am talking about the traditional Remote Desktop Connection application on the Desktop that was in previous Windows versions, not the Remote Desktop App from the Windows 8 store.
When I try to click on the Save button I get "An error occurred while saving to file"
When I try to click on the Save As button I get "Unable to open connection file" with the file address being where I tried to save it with the file name at the end.
Also when I upgraded to Windows 8, my .rdp files disappeared from my Documents folder.
I need to create different .rdp files for different programs that my employees get into on my server. Now I have to hand type all the info each time into the Programs tap on the Remote Desktop Connection window, because I can't save to an .rdp file.
I like the Remote Desktop App from the Windows store but it won't let me designate specific programs to use using standard dos notation (ie c:\program files\ etc..). It just goes to my server desktop.
I want to promote Windows 8 to my employees but I need either .rdp files for the traditional Remote Desktop Connection or the ability to open specific programs using dos notation in the Windows Store Remote Desktop App.
Reply:
Hi,
I can save the .rdp file into desktop in my environment.
You may go to Event Viewer to check if there is any related log.
Kim Zhou
TechNet Community Support
------------------------------------
Reply:
exactly my experience. I also get the "Unable to open connection file"; which is odd as we aren't trying to open the file, but to save it. I upgraded from win7.
let me know if you get anywhere with it! I prefer to continue to use my existing RDC application too.
------------------------------------
Reply:
Hi,
Also for me, do you find a solution ?
------------------------------------
Reply:
I know this is an old post but others might still be having the problem. Here's what I did.
Create a new text file and open it in notepad. Copy the below into it and edit for your environment. (IP, screen size).
screen mode id:i:2
desktopwidth:i:1920
desktopheight:i:1080
session bpp:i:24
auto connect:i:0
full address:s:192.168.x.x
compression:i:0
keyboardhook:i:2
audiomode:i:2
redirectdrives:i:1
redirectprinters:i:1
redirectcomports:i:1
redirectsmartcards:i:1
displayconnectionbar:i:1
username:s:USERNAME
domain:s:DOMAIN
alternate shell:s:
shell working directory:s:
disable wallpaper:i:1
disable full window drag:i:1
disable menu anims:i:1
disable themes:i:1
bitmapcachepersistenable:i:1
use multimon:i:0
winposstr:s:0,3,0,0,800,600
audiocapturemode:i:1
videoplaybackmode:i:1
connection type:i:7
networkautodetect:i:1
bandwidthautodetect:i:1
enableworkspacereconnect:i:0
allow font smoothing:i:0
allow desktop com:0
disable cursor setting:i:0
redirectclipboard:i:1
redirectposdevices:i:0
drivestoredirect:s:*
autoreconnection enabled:i:1
authentication level:i:2
prompt for credentials:i:0
negotiate security layer:i:1
remoteapplicationmode:i:0
gatewayhostname:s:
gatewayusagemethod:i:4
gatewaycredentialssource:i:4
gatewayprofileusagemethod:i:0
promptcredentialonce:i:0
gatewaybrokeringtype:i:0
use redirection server name:i:0
rdgiskdcproxy:i:0
kdcproxyname:s:
You don't need to worry too much about what's in here. Save the text file as filename.rdp then rightclick on the file and select edit. The familiar GUI rdp session editor will open. You can make changes in the GUI and save or save as a different session.
Hope this helps.
- Edited by Jimdwa Friday, February 21, 2014 3:11 PM
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
Worked for me, too.
I couldn't save the RDP file anywhere from within the RDP program. I could create a file on the desktop (and everywhere else) so I did what Jimdwa suggested and it worked.
------------------------------------
Problems to generate report in SRSS 2005
I can't generate the report with command type SP, but command type TEXT I do.
I working with Windows 10 and Oracle 10.2.
This is the error: Could not generate a list of fileds for the query.
Additional info:
ORA-06550: line 1, column7:
PLS-00306: wrong number or types of arguments in call to 'function'
PL/SQL: statement ignored
(system.data.oracleclient)
Help Me please.
Reply:
------------------------------------
Reply:
Hello,
Thanks for reply, but the report used to work fine, maybe it was in the windows 10 update, before I used Windows 7.
------------------------------------
Cannot generate report in SRSS2005
Hi,
I Can't generate a report with command type SP, but with Command type TEXT I do.
SRSS 2005.
The error message is:
I'm working in Windows 10.
Reply:
------------------------------------
Internet working but have exclamation mark
I have two networks where just can not seam to put my fingure on this, all computers working fine, internet working quite fast shares working, DNS Actiive directory but computers are showing this yellow exclamation mark.
Can ping out can lookup agains DNS just recking my head on why its there and network and sharing centre is showing no internet connections however when I ping out its solid.
Any idea?
Reply:
What do you get if you run this in a command prompt? nslookup dns.msftncsi.com
The Network Connection Status Icon
https://blogs.technet.microsoft.com/networking/2012/12/20/the-network-connection-status-icon/
Windows 7 Network Awareness: How Windows knows it has an internet connection
http://blog.superuser.com/2011/05/16/windows-7-network-awareness/
Windows 7 is falsely reporting "No internet access"
https://answers.microsoft.com/en-us/windows/forum/windows_7-networking/windows-7-is-falsely-reporting-no-internet-access/d43df29a-4c7e-44ca-81e2-6f78ae494b6a
------------------------------------
Report - Top 30 in Last 30 Days - Service - Classification Categories for incidents
I am new to reporting and SQL, but after many hours of broken sql and then a little reading on how to do Joins, I was able to make this Query. I know I am always looking for helpful queries to make reports, and this one I hope will help someone else if they are seeking this information. This is probably child's play for most of you here, but I had zero input when trying to figure simpler queries out, so thought I would share.
Select Top 30 S.DisplayName as 'Business Service', Class.IncidentClassificationValue AS 'Incident Classification', Count(S.DisplayName) as 'Number of Incidents' from IncidentDim as I Join WorkItemDim W on I.EntityDimKey = W.EntityDimKey Join WorkItemAboutConfigItemFactvw R on R.WorkItemDimKey = W.WorkItemDimKey Join ConfigItemDim C on C.ConfigItemDimKey = R.WorkItemAboutConfigItem_ConfigItemDimKey Join ServiceDim S on S.EntityDimKey = C.EntityDimKey Join IncidentClassification Class on I.Classification_IncidentClassificationId = Class.IncidentClassificationId Where W.Id like 'IR[0-9]%[0-9]' and I.CreatedDate >= DATEADD(day,-30,getdate()) and R.WorkItemAboutConfigItem_ConfigItemDimKey = C.ConfigItemDimKey and C.EntityDimKey = S.EntityDimKey Group by S.DisplayName, Class.IncidentClassificationValue Order by Count(S.DisplayName) desc
P.S. Please let me know if any of the Views used in my query are not out of the box views, so I know not to share in the future.
No comments:
Post a Comment